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.
N4772TCaballeros Aircraft LLC · Snohomish, WAN4772YKnutson Wayne R · Tioga, NDN47737N47737 Holdings LLC · Gonzales, LAN47738Coady Thomas J · Wausau, WIN4773APaul W Michael · Sprague, WAN4773BRegistered aircraftN4773CDickert Daniel · Cross City, FLN4773KReason Farms · Yuba City, CAN4773PCoeur De Air LLC · Mcminnville, ORN4773SSonrex LLC · Auburn, INN4773THagerman John · Coxs Creek, KYN4773UFins Fur & Feathers Flying LLC · King Salmon, AKN47743Majic T Air LLC · Bradfordwoods, PAN4774AJewett Robert A · Wasilla, AKN4774BCunningham Martin Alden · Kansas City, MON4774EZhao Dan · New York, NYN4774FIlmberger Stephen J · Bend, ORN4774JAlbin John B · Milan, MIN4774KWingfield John J · Parker, TXN4775BChavez Edward C · Boise, IDN4775DHetrick-Price Willow · Anchorage, AKN4775KBas Part Sales LLC · Greeley, CON4775LWadkins Chris H · Plummer, IDN4775MJ And J Consulting LLC · South Jamesport, NYN4775NTennessee Metals Recycling LLC · Murray, KYN4775PRegistered aircraftN4775QShelk John Brian · Bend, ORN4775UBishop Mike · Rifle, CON47764Wl Aviation LLC · Olney, MDN47767Capps Clinton Wyatt · Navasota, TXN47768Registered aircraftN4776BLarsen Christopher F · Fairbanks, AKN4776EAlpha One Aviation LLC · Dunedin, FLN4776JKimbrough Paul E · Millcreek, UTN4776LHitt John C · Plano, TXN4776NRegistration Pending · Ceiba, PRRegistration pendingN4776THigh Planes Air Service · Bismarck, NDN4776UHabberstad John L · Rathdrum, IDN47773Walo Barry F · Cresson, TXN4777JHowell Michael A · Parsons, KSN4777LRoss Charles B · Anchorage, AKN4777NRosario Edwin A · Pine Island, NYN4777SN4777s LLC · Ault, CON4777UAdair Aviation LLC · Broken Arrow, OKN4778CDwstults Enterprises LLC · Winter Haven, FLN4778EClemmons Flyers LLC · Green Cove Springs, FLN4778FPond Engineering Laboratories Inc · Berthoud, CON4778LGarrett Russell K · Hazen, NDN4779TAmerican Aerial Patrol LLC · Saint Amant, LAN4779UBergh Eugene H · Roberts, WI
Back to AD 2007-04-19 R1