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.
N8288EGomez Cierra D · Jasper, ALN8288FAtwood Jason P · La Porte, INN8288JRegistration Pending · Oklahoma City, OKRegistration pendingN8288LFrenzel Aviation Investments LLC · Brentwood, TNN8288ZPabon Hugo · Granada Hills, CAN8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKN8289CSchilder Justin W · Faulkton, SDN8289GDutcher Kenneth J · Kingsland, TXN8289JCummings Steven R · League City, TXN8289XSheitelman Mitchell · Warren, NJN828AYoder Stephen · Melba, IDN828BMChristiansen Aviation LLC · Wilmington, DEN828BNTravelaire Service Inc · Pueblo, CON828DMPlane Fun Inc Tr Trustee · Snellville, GAN828FSPerformance Aircraft Sales Inc · Lincoln, NEN828HPParsons Harry · Bloomfield, NJN828HTHappy Trails Aviation LLC · Kalispell, MTN828JPCarney William F · Gallatin, TNN828JTAtems Elisabeth · Northfield, VTN828LPFlying Twenties Inc · San Jose, CAN828LSKelly Ryan · New York, NYN828LUMuldrow Erik · Newport, KYN828MCHub City Aviation Academy LLC · Lubbock, TXN828PLGrosso Michael F · Charleston, SCN828RVNewman Charles W · Petaluma, CAN828RWStankie Alexander M · Cocoa Beach, FLN828SPVista Aviation Inc · Pacoima, CAN828TSPlane Fun Inc Tr Trustee · Snellville, GAN828YLong Island Aviators LLC · Seaford, NYN82905Reese Melissa A · Soldotna, AKN82907Law Offices Of David Henderson · Anchorage, AKN8290CMckinney Steve R · Hamersville, OHN8290JSchaaf Rodney B · Bowman, NDN8290NHorne Larry E · Suffolk, VAN8290SNewsome Jeff · Blackwell, OKN8290WCastles James D · Portland, ORN82912Barrows Stuart L · Eagle River, AKN82918Herman Brant · Fairbanks, AKN8291CStober John · Goodrich, NDN8291ERangers Flying Club Inc · Eden Prairie, MNN8291GBullock Brooks M II · Cartersville, GAN8291JWorth William A · Anthony, NMN8291NPeters Rodney A Jr · Hayward, WIN8291WVoll Dorothe A · Corona, CAN82921New Hampshire Flying Association Inc · Nashua, NHN8292DHuffman Jacob M III · Burleson, TXN8292EP&N Corp · Marion, IAN8292JBrent Scott Properties Lp · Eagle, CON8292WPinegar Kevin R · Brighton, MIN8293CMcchargue Robert W II · Talkeetna, AK
Back to AD 90-04-06 R1