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.
N5403EBuness Timothy A · Wrangell, AKN5403FAcs Wings LLC · Deerfield Beach, FLN5403PSwartwood Scott S · Colorado City, CON5403VL & R Consulting LLC · Las Vegas, NVN54041Bowen John E · Ocala, FLN54048Hodge Flight Services LLC · Pittsburgh, CAN54049Pittinger Mitchell J · Reisterstown, MDN5404DRegistration Pending · Billings, MTRegistration pendingN5404HPool Hap · Vail, CON5404LRegistered aircraftN5404UHubbard James E · Dover, OHN5404WBas Part Sales LLC · Greeley, CON5405AN5405a LLC · Beverly Hills, CAN5405DKelln David R · Lawton, OKN5405LScalia Dennis · Westlake, LAN5405PJohnson Sidney · Madison, MNN5405URyan Good Aviation LLC · Sioux Falls, SDN54067St Pete Aviation Services LLC · Saint Petersburg, FLN5406AJanke Merle D II · Simi Valley, CAN5406LLone Roger D · Prosperity, SCN5406PDerksen Ronald E · Xenia, ILN5406WScott Jeffrey E · Connersville, INN5406YKillam Rodney A · Carlinville, ILN54073Center O Flying Club · Tumwater, WAN54079Christiansen Aviation LLC · Wilmington, DEN5407FFly Quest Aviation LLC · La Verne, CAN5407LStech Stuart · Fredericksburg, TXN5407WThird Step 6 LLC · Gilbert, AZN5408BLeonard James A · Boise, IDN5408ECutbirth Henry R · Monahans, TXN5408HSchmidt Kelly D · Lake Elmo, MNN5408NAviation Law LLC · Mesa, AZN5408PZero Eight Papa LLC · Dublin, OHN5408RRegistration Pending · Brookland, ARRegistration pendingN5408USanders Aviation Inc · Jasper, ALN5408WTriple M&W LLC · Bloomfield, IAN5408YHargreaves William A · Lovettsville, VAN54093Kamenev Alexey · Hinsdale, ILN54094Mustang Sally Aviation LLC · Camden, SCN5409DDay William L · Seguin, TXN5409FBlackwolfden Aviation LLC · Belgrade, MTN5409GRichland Aviation Inc · Sidney, MTN5409JKelley Aircraft LLC · Weyers Cave, VAN5409LBarnhardt Robin J · Eleva, WIN5409MJackson David B · Mansfield, TXN5409PReinaudi Gael · New York, NYN5409RMclane Tucker · Newton, MAN5409UCosco & Associates Inc · Crestview, FLN5409YLee Christopher · Katy, TXN540ABarnow Jeffrey W · Boulder, CO
Back to AD 2007-04-19 R1