AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N202JTHour Time Machine LLC · Bloomington, INN203RFRapid Flyers LLC · Rapid City, SDN204BRRand Joseph · Osprey, FLN207DVWiseman Charles N · Midland, MIN207WMG A Associates LLC · Port Orange, FLN209JAHowen Kyle Verne · San Luis Obispo, CAN20CAState Of California Department Of Transportation · Sacramento, CAN20LN303cj LLC #1 · Lexington, KYN210JEKoch Henry Thomas · Tampa, FLN210TAN210ta LLC · Jupiter, FLN2113QGlenelg Equipment Leasing LLC · Hanover, MDN211ACJames P Hill Distributor Inc · Ruston, LAN211AWWeis Aaron · Waban, MAN211CMMoneypit Investment Corp · Wilmington, DEN211LHLidzbarski Mark A · Southington, CTN211SEAircraft Guaranty Corp Trustee · Oklahoma City, OKN211TMPlane Fun Inc Tr Trustee · Snellville, GAN212BKVitesse Aviation Holding I LLC · Englewood, NJN212MMOlver Keith B · Annapolis, MDN212SRPegasus Flyers LLC · Queen Creek, AZN213CAAble 1 Aviation Inc · Las Vegas, NVN213CFSchantz David E Trustee · Raleigh, NCN213CPTitsworth Richard D · Novi, MIN213JWLipidex Corp · Marshfield, MAN213MLTrue Air Speed LLC · Saint Francisville, LAN213MPFly High Aircraft Sales LLC · Ocilla, GAN213PG213pg Inc · Chattanooga, TNN213RJCrw Enterprise Holdings LLC · Newark, DEN213SEAircraft Partner N213se Dst · BerlinN213SRDonegan Kevin M · Amissville, VAN213TBDonley John Roger · Eagle Lake, FLN213WDHamill Enterprises LLC · Reinholds, PAN214BBMessina Mark · Wallingford, CTN214BRBaba Daniel · Glastonbury, CTN214CLCx Aviation Inc Trustee · Wilmington, DEN214CPHollis Roofing Inc · Columbus, MSN214CTValiair Limited Co Trustee · Casper, WYN214DJAircraft Guaranty Corp Trustee · Oklahoma City, OKN214JGValiair Lc Trustee · Casper, WYN214TWRegistered aircraftN214TXAdams Randy K · Spicewood, TXN214VQSimply Living LLC · Fort Myers, FLN215ALUdaan LLC · Vienna, VAN215EBSalty Air LLC · Wayne, PAN215EMPostma Air LLC · Saint Paul, MNN215JPPilot Peak Adventures LLC · Ely, NVN215RRRednor Jeffrey · Yardley, PAN216DHRebel One LLC · Dover, DEN216LBell John · Linville, NCN216NGrb Aircraft Leasing LLC · West Fargo, ND
Back to AD 2007-24-13