AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N142WHendry James W · Cortez, CON142WBDay Craig · Braman, OKN14309Metz Daniel J · Brighton, CON1430HHardy John R · Wasilla, AKN1430XRuggiero Matthew J · New York, NYN1432JCarl Rodney Crews Jr · Shreveport, LAN1432TSmith David · Belleville, ILN1433CChristiansen Aviation LLC · Wilmington, DEN1433SIntrepid Air Services LLC · Raleigh, NCN1433TTilton Dave P · Bradyville, TNN1434JVance Tyler · Brighton, MAN1434TStrickland Jason · Gulfport, FLN14350Pema Aviation LLC · Tavernier, FLN1435TWaters Nicholas T · Claypool, INN14368Semeniuk Steven T · Houston, TXN1436JFlight Time Builders Inc · Memphis, TNN1436TDeland Aviation LLC · Deland, FLN14379Bas Part Sales LLC · Greeley, CON1437RMcis Aviation LLC · Wilmington, DEN14386Blue Star Aviation Services LLC · Shippensburg, PAN1438CTony And Oats Great Adventure LLC · Danville, INN1438JWall John R · Andover, OHN1438PTri Rotor Spray & Chemical · Ulysses, KSN14394Pavco Inc · Gig Harbor, WAN1439JBeckler Scott · Omaha, NEN143ACPotcake Aviation LLC · Missoula, MTN143BHTappan Holdings Inc · Cadiz, OHN143BSMoses Charles · West Friendship, MDN143CCAerial Messages Leasing Co · Longwood, FLN143DVBruns Luke J · Flower Mound, TXN143EBLewis Thomas B · Granbury, TXN143EEFour Bs Montana Ranch LLC · Kalispel, MTN143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN143GLLiebert Glenn W · New Albany, OHN143HAHartman Dave · Miles City, MTN143JDHarris Steven V · Springtown, TXFirst renewal noticeN143KYClark Michael B · Montgomery, TXN143LWMurphy Law Office Pc · Rapid City, SDN143MYPeaks Rental LLC · Aurora, CON143PROrtiz Ramon L · Teaneck, NJN143RNCollins Glen K Trustee · Appleton, NYN143RVLefevre Garrett R · Tucson, AZN143RWWendell Ross · Ankeny, IAN143SDWhiskey Fox Group LLC · Destin, FLN143SHSpitzer Helicopter LLC · Woodland Hills, CAN143TBSmith Timothy T · Turkey, NCN143ZLYoder F David · Wellington, FLN14401Berggren Ryan · Newton, NJN1440UPiper Aircraft Inc · Vero Beach, FLN1440XAlldredge Brad · Redlands, CA
Back to AD 2006-10-21