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.
N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNN54BCloud Nine Ventures LLC · Riverview, FLN54BAEmerald City Aircraft Leasing Inc · Port Orchard, WAN54BHListisen John S · Butler, PAN54BKDanny J Daigle LLC · Greenville, MEN54BWWalker D B · Rougemont, NCN54CBCb Wings LLC · Eugene, ORFirst renewal noticeN54CCScythe & Spade Co · Grand View, IDN54CSO'Shea James · West Grove, PAN54CTBrubaker Calvin · Midvale, UTN54DFSkywave Associates LLC · Spirit Lake, IAN54DGSaffron Aviation LLC · Carrollton, GAN54DLMorris Samuel A · Prineville, ORN54DZMcdonald Donald F · Greer, SCN54EHMcgyver Airshows LLC · Wilmington, DEN54EJHigh Plains Aviation LLC · Caro, MIN54ELCascade Air LLC · Trout Run, PAN54EMAvirone Ltd · Monsey, NYN54ETJhet Mt Holdings LLC · Helena, MTN54FDDefibaugh Fred M · Chino Valley, AZN54GACrosswind Leasing LLC · Prescott, AZN54GDCulpepper Mark D · Chapmansboro, TNN54GMCiommo William J · Spring Hill, FLN54GVAlaska Aircraft Leasing LLC · Silverdale, WAN54HThb34 LLC · Kalispell, MTN54HLOverbey Michael B · Houston, TXN54HMSky West Aviation Inc Trustee · Albuquerque, NMN54HRAshcraft Matthew Q · Abbott, TXN54HSHenderson State University · Arkadelphia, ARN54HYEngler Eric M DBA · Cass City, MIN54JASan Carlos Flight Center Inc · San Carlos, CAN54JMAviation Institute Of Maintenance · Virginia Beach, VAN54JNDlz Aviation LLC · Ostrander, OHN54JQRegistered aircraftN-number assigned (import), not yet registeredN54KAPoint To Point Air LLC · Arlington, WAN54KDSawtooth Flying Service Inc · Mccall, IDN54KF5193 Flight LLC · Missoula, MTFirst renewal noticeN54KHHertenstein Kevin Wayne · Lutz, FLN54KKTemple Donald G · Amarillo, TXN54KPScheuers Alan · Murfreesboro, TNN54LHolzsweig Leon Gerald · Dallas, TXN54LFTopliff John · Goodland, KSN54LHThrew Timothy G · Yates City, ILN54LJPoulton Douglas E · Castro Valley, CAN54LLRyan Good Aviation LLC · Sioux Falls, SDN54LRPterodactyl Inc · Wilmington, DEN54LULetourneau University · Longview, TXN54MDDe Marino Michael E · Marietta, GAN54MGCarley Kristopher · Sacramento, CAFirst renewal noticeN54MJNychka Robert James Paul · Wills Point, TX
Back to AD 2007-04-19 R1