AD 90-04-06 R1
Registered aircraft · 68,369
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.
N113JWGrass Roots Aviation LLC · Bend, ORN113JYFreeman Alan M · San Antonio, TXN113KRIal Corp · Lewes, DEN113MAMyllyla Ray J · Woodland Hills, CAN113MEButler Robyn L · Vale, ORN113MSFly2walk LLC · Loveland, CON113MXN113mx LLC · Redding, CAN113NShaw Brandon L · Juneau, AKN113PATundra Aviation Inc · Casselton, NDN113PCProp & Jet Air Museum Inc · Romoland, CAN113PJLang Carl · Harper, TXN113PVVaneau Philip M · Kerrville, TXN113RVMason Chance L · Elwood, INN113SJGlumac Stanley Jr · Grindstone, PAN113SWFargo Jet Center LLC · Fargo, NDN113TSMilitary Aviation Museum · Virginia Beach, VAN113UDRv8rs Anonymous LLC · Cincinnati, OHN113VGN113vg LLC · Princeton, NJN113WYRyals Barry · Rhine, GAN114Cooper Michael D · North Turner, MEN1140CAtkins Alvin R · Barnstead, NHN1140JGardner John D · Tallahassee, FLN1140PCromley Amanda J · Lewisburg, PAN1141Callaway Don · Leona Valley, CAN11411Baca Marciano A · Los Angeles, CAN1141MSunshine Flyers · Auburn, CAN1141UFlight School Inc · Spring, TXN11429Schwartz David J · Bellaire, MIN1142QSteely Paul · Williamsburg, KYN1143ENevarrow Leon · Spring Valley, CAN1143JDurrah Anthony E Sr · Charlotte, NCN1143MCastelletti Mark Anthony Trustee · Casa Grande, AZN1144AKramer John Edward · Conroe, TXN1144JLee Carl B · Bullard, TXN1144KYoung Bradley M · Vancouver, WAN1144LComposite Sign Products Inc · Zeeland, MIN1144MCcr Aviation LLC · Kalispell, MTN1144WNimmo Lawrence · Cordova, MDN1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeN1144ZBay Lux Ventures LLC · Tampa, FLN1145JPrestridge Austin · Newark, OHN1145TWilliams Thomas J · Burr Ridge, ILN1146LSak Aviation LLC · Cheney, KSN1146VPlane Cents LLC · Henderson, NVN1147N7371y LLC · Waterford, MIN11476Shannon Kenneth H · Washington, DCN1147JSandel Henry Adrian III · Natchez, MSN1147LLandry Lonny Reid · Fort Worth, TXN1147XPax Flyers LLC · Hollywood, MDN1148ATyrrell Luke L · Fairbanks, AK
Back to AD 90-04-06 R1