AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N733CZManning And Sons Property LLC · Summerville, SCN733DGReisz Michael E · Cresson, TXN733DL523 Flying Club · Williamson, WVN733DNTraining Planes LLC · Tampa, FLN733DPNiemi Aviation LLC · Glyndon, MNN733DRMarc Aircraft Holding LLC · Soldotna, AKN733DTForstner Christopher R · Hensler, NDN733DXWiechmann Donald G · Wagner, SDN733DZLarson Dylan J · Perham, MNN733EAJohnson Scott A · Cohasset, MNN733EBB&R Aircraft LLC · Wadsworth, OHN733EJBas Part Sales LLC · Greeley, CON733ELNc 86 Flying Club Inc · Mooresville, NCN733EMEricson William R · Traverse City, MIN733ENBurr Ralph M · Roanoke, VAN733EPSkytec Aviation LLC · Boynton Beach, FLN733EREmbry-Riddle Aeronautical University Inc · Prescott, AZN733ESWings Over Texas Holdings LLC · Denton, TXN733EVCriscolo John T · East Setauket, NYN733EWS S T & J LLC · Minden, NEN733EZBi Plane Adventures Inc · Kennesaw, GAN733FAJr Imaging Logistics Inc · Pasco, WAN733FCKelley Aircraft LLC · Weyers Cave, VAN733FFRising Wings Aviation Inc · Casper, WYN733FGPnw Aircraft Holdings LLC · Issaquah, WAN733FNJls Aviation LLC DBA · Fredericksburg, VAN733FPSorbi Aviation Inc · El Cajon, CAN733FRCrotts Aircraft Service Inc · Dodge City, KSN733FSArbach Enterprises Inc · Watertown, SDN733FTRegistration Pending · Blaine, MNRegistration pendingN733FUSimplifly LLC · Mesa, AZN733FXCynthiana Flying Group Corp · Cynthiana, KYN733GBDouble Bridges Aviation LLC · Enterprise, ALN733GCWilliams Steve A · Tamms, ILN733GKHearn Richard J · Gardner, KSN733GLWhitewater Aviation Inc · Harrison, OHN733GMHansen Jens E · Arroyo Grande, CAN733GPHorton Luther · Lakeland, FLN733GQMarc Aircraft Holding LLC · Soldotna, AKN733GSWings Over Texas Holdings LLC · Denton, TXN733GTSanchez Demolition Inc · Bosque, NMN733GVRiya Aviation LLC · Tracy, CAN733GXMarianas Air Transfer Inc · Saipan, MPN733GZRichardson Charley Mack II · Mount Pleasant, SCN733HAHuerta Holdings Inc · Santa Ana, CAN733HCWings Flight Enterprises Inc · Danville, KYN733HDFuqua Michael B · Chatham, VAN733HFVr Aerospace LLC · Seattle, WAN733HHThomas Ramone · Philadelphia, PAN733HJRegistration Pending · Bay Harbor Islands, FLRegistration pending
Back to AD 87-10-06 R1