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.
N518ERoland Kenneth R · Tell City, INN518EGStyer David B · Pendleton, ORN518GMMountain Escape LLC · Pullman, WAN518HJArmstrong Consolidated LLC · Anchorage, AKN518JGloc Aviation LLC · Afton, OKN518JSDubbs Chad T · Naples, FLN518LSeehimfly LLC · Spring, TXN518MMull Jason E · Chester, NYN518MDGreens Aviation LLC · Lebanon, OHN518MJPursuit 53 · College Station, TXN518PCJnc Holdings LLC · Mequon, WIN518PLMoore David P Trustee · Chattanooga, TNN518PUSalim Omar J · Olympia, WAN518QLab Aviation Corp · Montville, NJN518RMWinkelmann Pete J · North Fond Du Lac, WIN518RVFehrs Aviation LLC · Seminole, TXN518SDDykstra Scott E · Jenison, MIN518SJWoodward Aviation LLC · Alpine, TXN518SPGreater Flint Pilots Associations Inc · Flushing, MIN518SWGilchrist Robert T · White Salmon, WAN518TPos LLC · Glencoe, MON518TCBedell Gary L · Henderson, NVN518TJJohnson Travis · Wright City, MON518TPFaber James A · Coppell, TXN518TRCorrina Cumulus LLC · Kalispell, MTN518VKingsley Kiman J · Miller, MON5190DWalden James F · Willcox, AZN5190GFinney Billy D · Muncie, INN5190JAoa Kissimmee Inc · Kissimmee, FLN5190LKing Samantha M · Mcdonough, GAN5190RIasco Flight Training Inc · Redding, CAN5190SRobinson Richard D · Montclair, CAN5190TMhe Aviation LLC · Las Vegas, NVN5191Murray Stewart · Capay, CAN5191FArapahoe Aero Aircraft Sales LLC · Englewood, CON5191HPearce David W Trustee · Anchorage, AKN5191JN5191j LLC · Myrtle Beach, SCN5191LGravley Kevin · Wiggins, MSN5191RKlein Alan D · Hudson, WIN5191SBomar Christopher P · Munford, TNN5191URobles Marcos F · Oracle, AZN5191VTrue Drilling LLC · Casper, WYN51920Wilkinson Edward H · Aspers, PAN5192DJstream Lc · Sheridan, WYN5192GCarey International Aviation Services LLC · Long Beach, NYN5192HAlexander Steve T · Wasilla, AKN5192LKirkpatrick William J · Tyrone, PAN5192SCxo Time Builder LLC · Magnolia, TXN5192VStippich James A · Panama City, FLN5192XDavis Wayne W · Wakefield, RI
Back to AD 2007-04-19 R1