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.
N54MKKuhn Morris L · Dallas, TXN54MMGwinn Roger A · Maple, NCN54MTMay Rose Ellen · Hampshire, ILN54PFSilverado Land Management LLC · Sparks, NVN54PPHancock Andrew M · Kettle Falls, WAN54PRReimer Lynn C · Sioux Falls, SDN54PSAustin Bill DBA · Sparta, TNN54PWScheffers Lee · Riverside, CAN54RAerometrix LLC · Lawrence, KSN54RAAshlock Mark L · Loomis, CAN54RBWestmoreland Aerosports Inc · Murrysville, PAN54RFFrasca Lucille A · Urbana, ILN54RHWhite Parker K · Grass Valley, CAN54RLTrimble Steven L · Tallahassee, FLN54RRValentin Jose E · Murrieta, CAN54RSIreland Brian T · Springville, UTN54RVEbrahimi Mazda · Gerradstown, WVN54RWBaylis Thomas B · Hattiesburg, MSN54SDJerry W And Barbara J Smith Family Land Lllp · Blanca, CON54SGBiondo Nicholas P · Norfolk, VAN54TCK K Stevens Publishing Co · Astoria, ILN54TDG-Loc Fighters LLC · Wilmington, DEN54TF14123 Inc Trustee · Wilmington, DEN54TLArmstron Kevin L · Corvallis, ORN54TVAllen And Lambert Inc · Bolingbroke, GAN54TXBail Air LLC · Port Saint Lucie, FLN54VBas Part Sales LLC · Greeley, CON54VAFisheer Eric E · Memphis, TNN54VCStrahler Mark D · Peachtree City, GAN54VKPain Management And Aesthetics LLC · Celina, OHN54VVVoutour Ryan R · Tehachapi, CAN54WCFlorian Nathan A · Homosassa, FLN54WDHat Creek Aviation LLC · Hamilton, MTN54WEWilson Douglas E · Emporia, KSN54WMNemensky Jack · Southborough, MAN54WYBernegger Mark S · West Point, MSN54ZRPoehlmann Ralph T · Brenham, TXN54ZZNeuman Michael · Vashon, WAN55000Gross Flying Service Inc · Larned, KSN55001Eastern Stearman Inc Trustee · Leesburg, VAN55007Av8 Inc · Westborough, MAN5500BKay James L · Irvine, CAN5500CDuncan Robert L · Greenville, MSN5500DSmoky Mountain Vertical Services LLC · Kodak, TNN5500EAllen Aviation LLC · Houston, TXN5500FVernon Walter Benson · Denver, CON5500GCummings Terence J · Morgan Hill, CAN5500KMcintyre Ian C · Pace, FLN5500LWinchell Lawrence R · Salem, NJN5500MDecathlon Training Inc · Saint Louis, MO
Back to AD 2007-04-19 R1