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.
N4480JGonzalez Guadalupe G · Atwater, CAN4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNN4480SCook Christopher R · Manhattan, KSFirst renewal noticeN4480TSell Justin L · Lucerne, INN44817Tokach Nicholas J · Hinckley, OHN4481GRotor Leasing LLC · Indianapolis, INN4481JMusser Fred R · Severna Park, MDFirst renewal noticeN4481SAc Aviation LLC · Searcy, ARN4481TValdes Eusebio · Miami, FLN4481XSpence Johnn · Apache Junction, AZN4481ZTucker Jason M · Wasilla, AKN44820Volar Corp · El Cajon, CAN4482EStaton Stephen D · Soldotna, AKN4482GRotor Leasing LLC · Indianapolis, INN4482JWebe Properties LLC · Toledo, OHN4482RBarxbar Aviation LLC · Mesa, AZN4482TIdeal Aviation LLC · Auburn, PAN4482WWheels In The Well LLC · Jonesboro, ARN4482YMiller Andy D · Marana, AZN44836Monadnock Aviation Inc · Keene, NHN4483CRich Aden Gene · Sequim, WAN4483JHelms Tate · Lake Charles, LAN4483RRuf Timothy · Anchorage, AKN4483XBowers Gregory L · Greensboro, NCN4483ZWild Valley LLC · Wasilla, AKN44847Hill David F · Pembroke, MAN4484WRegistered aircraftN4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLN4484YMasterwings LLC · Princeton, KYN44855Marshall Xavier T · Carson, CAN44858Swaz Aviation LLC · Mesa, AZN4485ACrabb Philip E · Fairbanks, AKN4485FSaunders Raymond C III · Albuquerque, NMN4485HFrancesco Grasso · Lutherville, MDN4485SDickerson Stephen Sr · Frisco, TXN4485TKreigh Kevin M · Auburn, INN44863Jg Aviation LLC · Indianapolis, INN4486AAerro LLC · Argyle, TXN4486FRegistration Pending · Hague, VARegistration pendingN4486HJennings Sabina · Carson, CAN4486JHess Garrett J · Fullerton, CAN4486RAurora Aviation Lc · Pierce City, MON4486SPopadich Nicholas · Monroe, MIN4486WReynolds Eric Eugene · Weatherford, TXN4486YQuality Aviation Inc · Marana, AZN44872Allmond Aviation LLC · Peoria, ILN4487KMid Atlantic Air Museum · Reading, PAN4487PAccelerated Aviation Instruction LLC · Owatonna, MNN4487SHanson Raymond H · Thousand Oaks, CAN4487YWitthuhn Johnie B · Callaway, NE
Back to AD 2007-04-19 R1