AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3022WNorth Summit Aviation LLC · Middletown, DEN3022YW&M Piper Dakota LLC · Broken Arrow, OKN3022ZVan Helsdingen Riaan · Rapid City, SDN30230N30230 Aircraft Holdings LLC · North Charleston, SCN30231Pankratz Paul J · Lakeville, MNN30235Booher Harold D · Manchester, MON30238Nunley Dwight · Hawkins, TXN30239Jones Gary E · Orange, CAN3023CBlack Cloud Aviators Inc · Dubois, PAN3023DGehin-Scott Gilbert III · Rancocas, NJN3023FJones Clinton D · Santa Rosa Beach, FLN3023KVx Parts LLC · Portsmouth, NHN3023LBirge Chad W · Alcoa, TNN3023TInternational Air Services Inc Trustee · Carson City, NVN3023WBoughen James R · Camas, WAN3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeN30245Downing Douglas E · Troy, TXN30249Campbell Donald R · Lawrenceburg, KYN3024CCash Management Consulting LLC · Granite Springs, NYN3024FSutton Aircraft Salvage LLC · Palmer, AKN3024HMll Air LLC · Kalispell, MTN3024MTremie Chad M · Sulphur, LAN3024PPrentice Robert D · Ripon, WIN3024QJones Sean D · Adams, TNN3024YTemple Curtis Lee · Porcupine, SDN30250O'Connor Sean J · Newburyport, MAN3025CWonnenberg Douglas D · Menoken, NDN3025DBanducci Debra L Trustee · Bakersfield, CAN3025FWarner Daniel M · Fremont, OHN3025KWojteczko Jason A · Derby, KSN3025QTamborelli Keith · Kulpmont, PAN30260Schubert Mark J · Watkins, CON30268Rudd Terry R · Clarkston, WAN3026FMock1 LLC · Abingdon, VAN3026LBcmc LLC · Kalispell, MTN3026QSuper D Group LLC · Hanoverton, OHN3026YEpss LLC · Tavernier, FLN30275Tomlinson Douglas F · Waunakee, WIN30278Barron Joseph M · Des Moines, IAN3027CPelayo Fernando · La Puente, CAN3027FSale Reported · Watford City, NDSale reported, pending cancellationN3027PRobinson Helicopter Co · Torrance, CAN3027SG & M Aircraft Inc · Wheat Ridge, CON3027VKey Monty W · Seminole, TXN3027WS2 Helicopter Services LLC · Albany, TXN3027ZDavis Robert · Wasilla, AKN30280Emery Clint L · Texarkana, ARN30282Saucerman Equipment Leasing LLC · Indianapolis, INFirst renewal noticeN30285Galena City School District · Galena, AKN3028ERegistration Pending · Philadelphia, PARegistration pending
Back to AD 2007-04-19 R1