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.
N3015ZPittman Leo B · Stanfield, AZN30166De Jager Henry · Smithville Flats, NYN3016CMoore Todd M · Peoria, ILN3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeN3016FLosleben William L · Duvall, WAN3016MWild Wingdom LLC · Greenville, SCN3016NParker James C · Rescue, CAN3016QBarnes David L · Palmer, AKN3016TWilson Michael L · Santa Maria, CAN3016WBramble And Schaffer Aviation LLC · Raleigh, NCN3016YWood James D · Mineral Bluff, GAN30173Tolman William C · Maryville, TNN30179Kowatra Anil K · Lilburn, GAN3017HDavis Ronald C · Bloomington, MNN3017PDragonfly Aviation LLC · Mirando City, TXN3017WKirk Michael E · Alvin, TXN30182Johnson Arnold R · Mina, SDN30184Cp Aviation Inc · Santa Paula, CAN30189Onguard Aviation LLC · Cottonwood Falls, KSN3018FDietzler James J · Weyauwega, WIN3018QAndre Eric J · Somerset, WIN3018SPerez Daniel · Pembroke Pines, FLN3018YGranger Airplane LLC · Granger, INN3018ZGorman Robert L · Los Gatos, CAN30195Palmer Peter L · Mission, TXN30198Thomas Mark J · Vacaville, CAN3019FMadison Richard Christopher · Little Rock, ARN3019LWatkins Daniel J · Kennett Square, PAN3019PNelson Matthew J · Frewsburg, NYN3019QHatfield Brothers LLC · Gooding, IDN3019SSmith Jason E · Calliham, TXN3019TDanner Eric C · Benton, KSN3019YSheets Jeffrey M · Salmon, IDN301ACFlying Squirrel Aviation LLC · Shirley, MAN301AVJackson Charles A · Winchester, KYN301BHTraxler Shane C · West Monroe, LAN301BLPiper Aircraft Inc · Vero Beach, FLN301BPPrecision Aviators LLC · Iuka, ILN301BZPin High LLC · Ruston, LAN301CFSunrise Aviation Inc · Ormond Beach, FLN301CPWhy Not Fly Aviation LLC · Gainesville, VAN301CTVatm Sky Investments LLC · Thomson, GAN301DBDon Davis Aviation Inc · Henderson, KYN301DDRockalong Holdings LLC · Stanton, TXN301DETentacle Corp · Walnut Creek, CAN301EHinckley Harry W · Coralville, IAN301EBQuesnel William G · Truckee, CAN301ECF N A Aviation LLC · Wakefield, MAN301EFRegistered aircraftN301EMMcconwell Edward A · Mission, KS
Back to AD 2007-04-19 R1