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.
N4903DSam Air LLC · Madison, SDN4903LPlane Crazy Aviation LLC · Hollywood, SCN4903NDroke Paul Dan Jr · Coalgate, OKN4904GC & W Aviation LLC · Trumbull, CTN4904JLunken Air Group LLC · Cincinnati, OHN4904LSchmick David D · Sturgis, MIN4904PCivil Air Support LLC · Phoenix, AZN4904QFoxtrot Air LLC · Highmore, SDN4904SO Neil Mark F · Suffolk, VAN4904UMcdonald Patrick B · Brownwood, TXN4905AAnderson Ryan Alexander · Minnetrista, MNN4905CAnacapa Capital LLC · Fresno, CAN4905JMoore Albert III · Las Vegas, NVN4905RFlight Level Zero LLC · Othello, WAN4905UPerformance Ag Indiana · Frankfort, INN4906DHutchison Robert T · Big Lake, AKN4906JSeal Air LLC · San Juan Capo, CAN4906LRitter Steven L · Harlingen, TXN4906NKmq Data Acquisitions LLC · Chugiak, AKN4906SSweeney Peter Allan · Irvine, CAN4906TSmith Bruce · Leonardtown, MDN4907JHarmon Neil A · North Chelmsford, MAN4907LSmooth Landin Inc · Melville, NYN4907PTabor Conor C · Littleton, CON4907RMills Spraying Service Inc · Pahokee, FLN4907TPhoenix East Aviation LLC · Daytona Beach, FLN4907ZChristie Ian A H · Limon, CON4908Ballew Jackie C · Rogersville, MON4908JHolm R Stan · College Place, WAN4908PJohnson Dalton S · Sterling, AKN4908Q1lowflyer Inc · Harrisonville, MON4909ANastro Kristopher Jason · Fallon, NVN4909GRed Arrow Aviation LLC · Santa Teresa, NMN4909SRice Philip V · Sublette, KSN4909UGarner Howard E · Bonifay, FLN4909YFremont Airways LLC · Riverton, WYN490AFEiffert Matthew T · Ukiah, CAN490BYancey Patrick D · Spirit Lake, IDN490CPCivil Air Patrol · Maxwell Afb, ALN490DBPatkotak Crawford · Barrow, AKN490DLWhidden William L · Lake Wales, FLN490EREmbry-Riddle Aeronautical University · Daytona Beach, FLN490GRWarnock Tony J · Mobile, ALN490HPBreit Sky Aviation LLC · Sioux Falls, SDN490KMRasf414 LLC · Hallandale Beach, FLN490LLAntel Av Corp · Lewes, DEN490MLegacy Ofs Construction LLC · Stillwater, OKN490NWGalvin Flight Services Hawaii LLC · Honolulu, HIN490RRegistered aircraftN490RVSmith William R · Seneca, PA
Back to AD 2007-04-19 R1