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.
N44538Berkshire Aviation Enterprises LLC · Great Barrington, MAN4453ANau Evan D · Manchester, MIN4453RJackson Robin D · Harlan, IAN4453ZBoyer Skip P · Oak Harbor, WAN44542Waldraff Hans C · Delafield, WIN44543Evers Jeffrey P · Export, PAN44546Polka Todd M · New Philadelphia, OHN4454AMcclanahan Luke D · Decherd, TNFirst renewal noticeN4454HRobinson Terry J · West Chester, PAN4454JEvans Craig · Bastrop, LAN4454MTwitchell Matt D · Venice, UTN4454RDekle Drew · Athens, GAN4454ZWilliams Kenneth J · Wasilla, AKN44553Murrell Stanley D · Alabaster, ALN44555Miloud Chadd K · Fort Worth, TXN44556Sayonara Air LLC · Old Hickory, TNN4455HFrance Gary L · West Salem, OHN4455MClear Prop LLC · Roswell, GAN4455TK-T Customs LLC · Mustang, OKN4455XHarding Candace B · Livermore, CAN4455ZWindsor Greg A · Anchorage, AKN44566Skybound Aviation LLC · Kernersville, NCN4456HStewart Dan R · Cashmere, WAN4456RTruskey David R · Dauphin, PAN4456XFly By Knight Corp · Shoreview, MNN4456ZHayton James B · Sedro Woolley, WAN44571Boas Mark S · Hollywood, MDN44572Hornet Aviation Inc · Tallahassee, FLN44575Fit Overflow LLC · Davidson, NCN44579Schaible Peter J · Springfield, VAN4457BCelestina Harold C · Ester, AKN4457MLunceford Jerry W · Corpus Christi, TXN4457PSkyhaven Airport Inc · Tunkhannock, PAN4457ZK Ranches Aviation · Bozeman, MTN44580Mtt Aviation Services Inc · Johnstown, PAN44583Griffin Avionics Inc · Hyannis, MAN44584Boomerang Air LLC · Cedar Park, TXN4458JMillan Sanchez Omar · Sussex, NJN4458MRickard William A · Virginia Beach, VAN4458ZAerial Crop Care Co · Hebron, NDN4459Woods Donald E · Great Falls, MTN44590Lee John Michael · Van Nuys, CAN44592Registration Pending · Venice, FLRegistration pendingN44593Mcgaughey Kevin B · Milan, TNN44597Tob Cherokee Flyers · Kasson, MNN4459HClements Edward L · Fruita, CON4459JCoastal Virginia Aviation LLC · Chesapeake, VAN445ACTholen Susan M · Kennebunk, MEN445AFPlane Nonsense Inc · Middletown, DEN445DChristiansen Aviation LLC · Wilmington, DE
Back to AD 90-04-06 R1