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.
N5208RL & S Flyer LLC · Old Saybrook, CTN5208TGarrett Jerry M · Shreveport, LAN5208ZArnold Tyler S · Montgomery, LAN52090Bradley Flying Assoc · Peoria, ILN52093Helgeson Jeffrey D · Colonia, NJFirst renewal noticeN5209HCook James F · Portland, ORN5209LKing Christian T · Rhinelander, WIN5209RGuyer Kasey A · Billings, MTN5209VHawkbill Aviation LLC · Hudson, NCN5209WBeck Richard C · Wellington, ALN520ALentz Blaine D · Laramie, WYN520AFAmeriflyers Of Texas Inc · Addison, TXN520BBJ S Aviation Corp · Farmingdale, NYN520BSHanshew James M · Phoenix, AZN520BWWheadon William J · Napa, CAN520CAGruia Alin · Beaverton, ORN520CWCentral Washington University · Ellensburg, WAN520FLSiry Kristina · Mertztown, PAN520HKirsch Kenneth L · Carneys Point, NJN520MSH2 Link Co · Chino, CAN520PBoggs Kevin D · Washington, PAN520PPAdams Shannon I · Punta Gorda, FLN520QLFroehlich Lawrence F · Melville, NYN520RRRauch Richard B · Wilsonville, ORN520TXWalker Ronald J · Cedar Park, TXN520VTPlane Fun Inc Tr Trustee · Snellville, GAN520XSwaz Aviation LLC · Mesa, AZN52100Delta State University · Cleveland, MSN52101Defontes Kenneth W Jr · Kingsville, MDN52106Simmons Aviation Services LLC · Pawcatuck, CTN5210FSloan Nathan S · Owensboro, KYN5210LDewilde Lee Ray · Huslia, AKN5210RPrince Steven S · Westerly, RIN5210T51st Aero Squadron LLC · Hoover, ALN5211Dacy Julia A · Harvard, ILN52119Big E LLC · Lemoore, CAN5211LDuncan Timothy Scott · Sioux Falls, SDN5211MSinger Seth · Suffern, NYN5211WRupesh Patel · Waycross, GAN5211ZFlightwerx Inc · Deland, FLN52120Compass Aviation Maintenance LLC · Shelby, NCN52123Titop Ltd · Wilmington, DEN5212BMarble Toby J · Reno, NVN5212EFinley Bryce · Sandy, UTN5212KNew England Aviation LLC · Plainville, CTN5212ZYetter Mark A · Georgetown, PAN52132Registered aircraftN52139Mann Aviation Inc · Long Beach, CAN5213HWelding James D · Hilliards, PAN5213LSchultz Lillian I · Henderson, TX
Back to AD 90-04-06 R1