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.
N4158YAlliance Aircraft Sales Inc · Pierre, SDN4158ZSchaetzel Paul Robert · New Meadows, IDN41593Flyin LLC · Hyde Park, UTN41594Butler John P · Hazelhurst, WIN41598Fox Flying Club Inc · Wheaton, ILN4159AHauser Associates Inc · Coral Gables, FLN4159DBachman Aviation LLC · Independence, IAN4159HSponsler Frederic L · Fox River Grove, ILN4159KRegistered aircraftN4159MShapnek Lawrence R · Cedar Crest, NMN4159PSparks Brian E · Monmouth, ORN4159SCrew Marshall D · Spokane, WAN4159XHagglund Carl D · Pendleton, ORN4159YBauer Aviation LLC · Reese, MIN415AMUtah State University · Logan, UTN415BDWhiting Ian W · Coto De Caza, CAN415CAFly For Fun Aircraft LLC · Baltimore, MDN415CFAlo Fliteline Lc · Waterloo, IAN415GKCentral Clinton County Flying Club Inc · Jersey Shore, PAN415GSKirkman Robert Nolan · Pilot Mountain, NCN415HPRichmond George H Jr · Elkhorn, NEN415JBBrewer Allen E · Madison, MSN415KGSky Safety Inc · San Antonio, TXN415MEngelien Wendell · Port Orange, FLN415MRKropp Matthew M · North Creek, NYN415MSNextgen Flight Academy Inc · Riverside, CAN415PABird Acquisition LLC · Phoenix, AZN415RGalyon Aviation LLC · Sweetwater, TNN415SGriffing Flying Service Inc · Port Clinton, OHN415WHPaavola Troy E · Kansas City, MON41604Schuur Rodney E · Slayton, MNN41606My Flight LLC · Cypress, TXN41609Worthington John F II · Russiaville, INN4160DThompson Johnny J E · Coppell, TXN4160FYatin Servet · Weston, MAN4160JIvy James E · Alba, TXN4160POgle Richard W Jr · Joplin, MON41614Cartier Edward J Jr · Columbia, MSN41618Evv Warrior LLC · Evansville, INN41619Charles City Aeronautics Inc · Charles City, IAN4161JRegistration Pending · Hardinsburg, KYRegistration pendingN4161PRegistered aircraftN4161ZAri Ben Aviator Inc · Fort Pierce, FLN41622Stingray LLC · Kalispell, MTN41623Airplanesusa LLC · Schaumburg, ILN4162YGarrels Gregory J · Salcha, AKN41639Airmotive Service LLC · Brigham City, UTN4163BHarrop Blake N · Willard, UTN4163FHammans Gail A · Hot Springs, ARN4163HPetro Jerry R · Williamsburg, VA
Back to AD 90-04-06 R1