AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N608FTFlorida Institute Of Technology · Melbourne, FLN608GCareer Pilot Training LLC · Wilmington, DEN608MABair Jay D · Ephrata, WAN608PTAzure Leasing LLC · Oakdale, PAN608SCovey John R · Amboy, MNN6090BPlane Fun Inc Tr Trustee · Snellville, GAN6090DWoolard Wayne W · Bath, NCN6090FAmeriflyers Of Texas Inc · Addison, TXN6090LDarcor Inc · Hampstead, NCN6090VRoberts Jon J · Parker, CON6090XAstle James H · Saint John, KSN6091DMentone Flying Club · Rochester, INN6091FAmeriflyers Of Texas Inc · Addison, TXN6091LMartino John F · Kingston, NYN6091MGollobit Matthew W · Pierce, NEN6091QBridges Jeffrey Kemp · Cumming, GAN6091VJames Jay C · Mesa, AZN60924Interior & Arctic Alaska Aeronautical Foundation · Fairbanks, AKN6092DTanner Flying Service Inc · Cortez, CON6092FJasper Aviation Inc · Jasper, ALN6092MSchmucker Daniel · Bryn Athyn, PAN6092VAir Venture LLC · Au Gres, MIN6092WBoling Bret J · Wichita, KSN6093Dory Joseph A · Star, IDN60938Thomas Michael F · Glennallen, AKN6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeN6093WLee Richard L · Bowie, TXN6094DVan Wagner Aerial Media LLC · Hollywood, FLN6094FBuiqui Aerospace Corp · Kissimmee, FLN6094NAmerican Aviator LLC · Arlington, TXN6094QRakes Bobby N Jr · Saint Robert, MON6094RBoston Executive Helicopters LLC · Norwood, MAN6095SAri Ben Aviator Inc · Fort Pierce, FLN6096FColeman Gregory M · Chewelah, WAN6096LC&C Airlines LLC · Mesa, AZN6096XBergman James H · Buckley, WAN6096ZYoung Collin H · Spring, TXN6097FAmeriflyers Of Texas Inc · Addison, TXN6097LPetrovich Michael · Simpsonville, SCN6097MPea-Wayman Flight LLC · Daytona Beach, FLN6097PGuest Aviation LLC · Crane Hill, ALN6097WWallette Robert Michael · Port Saint Lucie, FLN6098DShurtleff Russell D · Tunkhannock, PAN6098FAmeriflyers Of Texas Inc · Addison, TXN6098LGrosvenor Robert I · Belle, MON6098NRegistered aircraftN6098WFall Line Aviation LLC · Augusta, GAN6099QBas Part Sales LLC · Greeley, CON6099XStar Larry D · Gold Hill, NCN609DCBarber Aircraft LLC · Topping, VA
Back to AD 90-04-06 R1