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.
N84036Wings Over Texas Holdings LLC · Denton, TXN8403EChurchill Scott W · Le Sueur, MNN8403LAarow Aircraft Leasing LLC · Mcminnville, ORN8403RSenmounnarath Sam · Murfreesboro, TNN8403YBlair Robert A · Red Bluff, CAN84048Kyzer Aviation Holdings LLC · Fort Mill, SCN8404CLudwick Paul W · Lighthouse Point, FLN84050Alpenglow Air 2 LLC · Anchorage, AKN84054Far Horizons LLC · Ravenel, SCN8405BMiloud Chadd K · Fort Worth, TXN8405MWilson Howard C · Georgetown, TXN8405RShields Parker · Port Orange, FLN8405SAlston Tony · Midland, TXN8405WTaylor Dale E · Kimball, SDN8405YBjorkman Marvin S · Richardson, TXN8406244 Flyers · Harlowton, MTN84063Rothermel Donald M · Mokena, ILN8406AColorado High Flyers LLC · Colorado Springs, CON8406HP A Flying LLC · Pueblo, COFirst renewal noticeN8406LVee Neal Aviation · Latrobe, PAN8406WWright Jordan M · York, SCN8406YPilgrim Robert C · Cape Coral, FLN84071Roadrunner Flight School LLC · Farmington, NMN84072Ferre Taylor · Kirkland, WAN84076Third Step 3 LLC · Gilbert, AZN8407DRegistration Pending · Manassa, CORegistration pendingN8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIN8407MJohnson Michele J · Buena Vista, CON8407PMark Gary Flying Service Inc · Inverness, MSN8407WIsland Flyers LLC · Apopka, FLN8407YAwad Aviation LLC · Pooler, GAN84082Weinheimer Paul T · Amarillo, TXN84086Smoky Mountain Flyers · Murphy, NCN8408BCharlton Gary R II · Loudonville, NYN8408CDallas Secure Storage LLC · Dallas, ORN8408DAeromarine Consulting Inc · Brandon, FLN8408ECandace A Larned Enterprises Inc · Long Beach, CAN8408LMacair Aviation LLC · Xenia, OHN8408RWilliams Christopher A · Kent, WAN84092Brown Stephen J · Chandler, AZN84093Hruska Coyle J · Lime Springs, IAN84097Argoudelis Michael · Kalamazoo, MIN8409DWinters David W · Gustine, TXN8409LRegistered aircraftN8409PStevenson Gregory J · Sutter Creek, CAN8409RRatliff Christopher · Manteno, ILN8409WMessam Andre · Snellville, GAN840ABDiamond Group Holdings LLC · Greenville, NCN840CWCentral Washington University · Ellensburg, WAN840TCNorth Star Aviation Inc · Mankato, MN
Back to AD 90-04-06 R1