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.
N573JCCoffey John L · Iron River, WIN573JFHuddleston Edward L · Oaktown, INN573MBWigley Barry L · Langston, ALN573MWWhelan Company LLC · Hoover, ALN573NDAir Shares LLC · Casper, WYN573PUTrustees Of Purdue University · West Lafayette, INN573SMason Scott C · Lebanon, ORN573TLAsson David A · Sisters, ORN573TMFarley Douglas C · Edmond, OKN574Yunt David W · Springboro, OHN57401Adams Kenneth · Marana, AZN57405Shoaf Douglas G · Lake Oswego, ORN57407Britt Elaine L · Locust Grove, GAN57408Phillips Thomas G · Fairbanks, AKN5740BPash Olin M · Harlan, IAN5740JStonestreet Arlie D Trustee · Pratt, KSN5740MSiemens Jonathan · Seminole, TXN5740QOasis Aero Inc · Willmar, MNN5740UBraden Daniel · Port Charlotte, FLN5740WAdams Clay · Anacortes, WAN57411Gregory Larry C Trustee · Farmington, MON57412North County Flight Training Inc · Carlsbad, CAN57413Miller Sybille A · Ashburn, VAN5741BCansino Ross G · George West, TXN5741DJ&H Sewing & Vacuum Inc · Soldotna, AKN5741FBrower Alan L · Califon, NJN5741MCoolidge Robert · Rio Vista, TXN5741VSjr Properties LLC · Reno, NVN5741WGonzalez Jose M · Arlington, TXN57421Snider Roger A · Harlem, MTN57422Heefner Frederick C · Greencastle, PAN57423Pardue Roy S · Clifton, VAN57424Wood Flying Inc · Panhandle, TXN57428Zygomalas Stefanos · San Francisco, CAN5742DHemminger Blair · Gwinner, NDN5742KCygnet Aerospace Corp · Los Osos, CAN5742MAmerican Aerial Survey Inc · Rancho Murieta, CAN5742UAdams Sara · Leavenworth, KSN5742VAllen Bruce C · Anna, TXN5742WJohnson Ronald H · Goodlettsville, TNN5742ZBootz Terry A · Canyon Lake, TXN57433Propwash LLC · Princeville, ILN57435Morkassel Gerald N · Waverly, OHN5743JMidwest Aerial Photography · Galloway, OHN57442Whiting Lawrence M · Silverton, ORN57446Williams Martin · Wasilla, AKN57447Hicks Richard Ted · Statesville, NCN5744BMcgrew Robert P III · Red Bluff, CAN5744DDempsey Timothy P · Pacific, MON5744KFlores Isael DBA Flores & Flores Trucking · Bloomington, CA
Back to AD 2007-04-19 R1