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.
N272SCRobert Gardner Enterprises LLC · Mercer, MEN272SDVigneault Leonard J · Southbridge, MAN272SEFoley Aviation LLC · Evans City, PAN272SGLehner Raymond A Jr · North Fort Myers, FLN272TWillis Patrick A · Eugene, ORN272TCMiller Ralph · Fleming Island, FLN272TLSanders Flight Training Center · Jasper, ALN272TNReed Perry L · Mooresville, NCN272VWigley Ben Jr · Huntington, ORN272VXSpence Lorne J · Saint Cloud, FLN272WCCandace A Larned Enterprises Inc · Long Beach, CAN272WYSale Reported · Eden Prairie, MNSale reported, canceledN272ZMarson Richard W · Eagle River, AKN27300Rankin Kevin J · Maryville, MON2730ASteigenga Nathan L · Suffolk, VAN2730EOew Aviation LLC · Sumter, SCN2730MSua LLC · Artesia, NMN2730QSkylane Corp · Pittston, PAN2730RRp Aviation Inc · Alliance, OHN2730WKegg Larry R · Chesapeake, VAN2730XSmith Daniel E · Anchorage, AKN2731KYoung Aviation LLC · Oshkosh, WIN2731MBosn Richard O · Scottsbluff, NEN2731Q31q LLC · Boise, IDN2731TFocus LLC · Missoula, MTN2731WUsrey Curtis R · Sullivan, INN2731YGeorgia Forestry Commission · Macon, GAN2732GPrince Benjamin D · Lincoln, MTN2732KDixie Sand And Gravel LLC · Edisto Island, SCN2732TJellor Realty Inc · Los Angeles, CAN2732WReik Martina · Novi, MIN27339Rice John G · Craig, AKN2733FMetzger William M · Boonville, INN2733GSkydive Ky LLC · Cecilia, KYN2733KRegistered aircraftN2733RPatrick Barb · Farmer City, ILN2733WMclenaghan Alvin N · Phoenix, AZN27347Cochran Douglas C · Saranac Lake, NYN2734BStella Air Inc · Wyoming, PAN2734FWard Christopher C · Lufkin, TXN2734GSplit Rock Aerospace LLC · Southport, CTN2734HGriebel Kyle L · Lafayette, CON2734Q1175 Bangtail Way LLC · Greycliff, MTN2735JAlpha 414a LLC · New Smyrna Beach, FLN2735KCook Kyle R · Green Valley, AZN2735PTaylor William W Jr · Hudson Oaks, TXN2735QRegistration Pending · Hearne, TXRegistration pendingN2735TWhite Michael W · Key Largo, FLN2736GFor Skies Flying Club Ltd · Martinsville, ILN2736KP M Logistics LLC · Haskell, OK
Back to AD 2007-04-19 R1