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.
N44AYPartin Kathy L · Nacogdoches, TXN44BAKnop Horacio M · Miami, FLN44BKBirum Kevin M · Kingston, WAN44BLBoehr Greg J · Mc Cool Junction, NEN44BWMariani Aviation Services LLC · Vero Beach, FLN44CHRunyon Aviation LLC · Fort Worth, TXN44CUAirstar Aviation LLC · Manawa, WIN44CZHeer James A · Lutz, FLN44DMGorge Winds Aviation Inc · Fairview, ORN44EBray Nick R Trustee · China Spring, TXN44EWPlane Fun Inc Tr Trustee · Snellville, GAN44FDHildreth David M · Kennesaw, GAN44FMHolmgren David P · Kamas, UTN44FSJinsky Ronald G · Beloit, WIN44GDCarver Michael A · Ocala, FLN44HKBradt Joseph J · Inver Grove, MNN44HUFritsche James G · Greenleaf, WIN44HYCochran Thomas S · Fort Collins, CON44JLBushcat Goldie LLC · Oro Valley, AZN44JRRodgers Jerry T · Bishop, CAN44KDSale Reported · Crystal, MNSale reported, canceledN44KLStell Brandon A · Mechanicsville, VAN44KPHargrave Margarite D · Seattle, WAN44LFFry Larry D · Ocala, FLN44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeN44LRRouse Peter L · Parkville, MON44LTLonderville Ross G · Stanwood, WAN44LYPuls Kurt V · Valparaiso, INN44MHDrewry James D · Dayton, TXN44MNBaker Larry M · Greenville, TXN44PDBurril Leslie A · Cleveland, GAN44PFVaayu Aviation LLC · Newark, CAN44PGSimon Jevon D · Buckley, WAN44PHHatch Fletcher A III · Vero Beach, FLN44PJSchaufenbuel Todd W · Imperial, NEN44PMPhipps Johnny · Salem, ORN44PPKnr Inc · Evanston, WYN44PWWeber Peter III Trustee · Loudon, TNN44PXMartinez Victor J · Sylmar, CAN44PYSegler Angela U · Marco Island, FLN44QGraf Erwin · Clayton, NCN44RRRichardson Robert L · Rch Palos Vrd, CAN44RTWinkelman Dan · Bethel, AKN44SDKandle Douglas A · Boise, IDN44SJHarpreet Sandhu · Livermore, CAN44SMHinds Community College · Raymond, MSN44STTakvorian Sevag · West New York, NJN44TCKinzie Hon K · Anchorage, AKN44TDChristian Joe L · Naylor, GAN44VTNelson William R · Caldwell, ID
Back to AD 90-04-06 R1