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.
N3915EPiper Aircraft Inc · Vero Beach, FLN3915KPayne Garin Jay · Huntington Beach, CAN3915PDryer Lucien E · Boise, IDN3915RMaloney Kylee · Kingman, KSN3915ZHigh Exposure Inc · Wilmington, DEN3916KBell Clarence R · Pasadena, TXN3916TChnupa David Scott · Fishers, INN3916WSpiritaire Inc · Saint Louis, MON3916YMelagrano Jeffrey D · Scarsdale, NYN3916ZSimon Mitchell B · Edison, NJN3917DBlue Sky Powers N3917d LLC · Dover, DEN3917KBas Part Sales LLC · Greeley, CON3917MWells Brandon A · Mechanicsville, VAN3917THarrington-Zink Kristopher Michael · Port Richey, FLN3917WAir Tipton Inc · Tipton, IAN3917XVan Anda Aviation LLC · Apopka, FLN3917YSmf Multi Sports LLC · Lewes, DEN3917ZLittlejohn Travis J · Wichita, KSN3918MAstro Aviation LLC · Cross Plains, TNN3918QAviation Academy LLC · Wichita, KSN3918USutton Gary K · Rexburg, IDN3918ZLautrup Joel W · Palmer, AKN3919DPallet Rack Surplus Inc · Conyers, GAN3919KTerrell Thomas III · Edwards, ILN3919QMinot Aero Center · Minot, NDN3919WAir First LLC · Kalispell, MTN3919ZPrice Kenneth R Sr · Woodland, CAN391AJOreck Tom · Asheville, NCN391ASSlinkard Andrew L · Mesa, WAN391BGMatthews Marc D · Monticello, FLN391BRWagers Wings LLC · Cleveland Heights, OHN391DNational Training 1 LLC · Wilmington, DEN391DEHayes Eric G · Mobile, ALN391DMKirvida James M · Dellwood, MNFirst renewal noticeN391DWFrancis Richard P · Hamilton, MTN391ERegistration Pending · Dodge City, KSRegistration pendingN391JBBarber Mark E · Lighthouse Point, FLN391JCCooper Gerald W · Kennewick, WAN391KFMeeker James W · Irvine, CAN391KSKaiser David S · Georgetown, SCN391LTPowell Patrick C · Kenai, AKN391MAMilton Chuck · Onalaska, WAN391PT7640 Drilling LLC · Amarillo, TXN391RDWilcox Brian D · Roseville, MNN391SAndrews Patrick D · Neosho, MON391SCSkydive Pennsylvania Inc · Mercer, PAN391SPN391sp LLC A Series Of Aero Lease LLC · San Antonio, TXN391WHSheppard Harold Jr DBA · Riverton, WYN391ZKeene Keith · Houston, TXN3920KPeriklos Andreas · Aliso Viejo, CA
Back to AD 2007-04-19 R1