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.
N4038MAlyeska Helicopters LLC · Girdwood, AKN4038ZLutz Matthew S · Lewistown, MTN40398Emerald City Aircraft Leasing Inc · Port Orchard, WAN4039HReese William A Jr · Waynesboro, TNN4039MTodd Gary L · Kasilof, AKN4039PPetersen Clayton L · Albert Lea, MNN4039ZMeeker Airport Inc · Meeker, CON403ATNew Horizons Aviation Inc · Goshen, INN403BCSmith Kenneth W · Marble Falls, ARN403CPGreenblatt Steven · Macon, GAN403DTTimms Douglass D · Gouldsboro, MEN403JHRobinson Richard M · Dallesport, WAN403JREllman Brett M · Cardiff By The Sea, CAN403NAWadsworth Chad C · Lake Havasu City, AZN403RRodrian James A Trustee · Grafton, WIN403RCSalt Lake Community College · Salt Lake City, UTN403SPHillsboro Aero Academy LLC · Hillsboro, ORN403TSMccauley Terry D · Rogers, ARN403WDThomas Spencer S · New Castle, CON403WRRumburg William J · Gold Hill, NCN403ZAlpha Tango Aircraft LLC · Wilmington, DEN4040EWildman Air LLC · Mckinney, TXN4040HDevil Dusters Inc · Artesia, NMN4040ZAcme Cub Training Inc · Anchorage, AKN4041EBurns Charles R · Huntsville, ALN4041MSessions John L · Kirbyville, TXN4041SDuplantis Nolan W II · Saint Martinville, LAN40439Usoarflorida LLC · Fort Myers, FLN4043EL C Hanson Co · Helena, MTN4043HWeggel Roger F · Fairbanks, AKN4044DParker Helicopter LLC · Watsonville, CAN4044GFlyrs Field · Anchorage, AKN4044MRed Baron LLC · Kenai, AKN4044NLundquist Matthew Michael · Navarre, FLN4044ZHainline David O · Poway, CAN40451Gallego Javier · Diamond Bar, CAN4045MSchad Paul E · Gainesville, TXN4045NPrivate Flights Inc · Harleysville, PAN4045XHeikkila Delano K · Buxton, ORN4045ZEastman Gregory L · Pueblo, CON4046AN7047x-R22 LLC · Wilmington, DEN4046PMeyer Edward E · Bolingbrook, ILN4046ZSprik Robert Jay · Hamilton, MIN4047EMission2fly LLC · Athol, IDN4047XHarms Timothy W · Whittier, NCN4047ZGrunwaldt Peter J · Anchorage, AKN4048XMoorhead Equipment LLC · Belton, SCN4049NCulley Richard A · Scottsdale, AZN404AGSkywest Leasing Inc · St George, UTN404BHRegistered aircraft
Back to AD 90-04-06 R1