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.
N3682ZIliamna Air Taxi Inc · Iliamna, AKN36838Sapphire Air LLC · Keystone, CON3683RRegistered aircraftN3683WHaure Pierre II · Rayne, LAN36846Armbruster LLC · Amherst, OHN36847Thrash Howard G II · Lubbock, TXN3684ARegistered aircraftN3684CFly Away Aviation LLC · Folsom, LAN3684HAvex X Corp · Coral Gables, FLN3684LLucke Eva DBA · Minot, NDN3684RCulbert Megan C · Woodbury, NJN3684UToews Berton J · Casper, WYN3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeN3684ZStevenson William E · Sutton, AKN36855Aerial Digital Images LLC · Huntington Beach, CAN3685ABartlett Jeffrey D · Black Diamond, WAN3685QEaston Bryan L · Council Bluffs, IAN3685RRailey Dustin Ward · Broxton, GAN3685WJewell Warren · Seattle, WAN3685YWhite Lawrence L III · La Habra, CAN3685ZMaus Christopher J · Anchorage, AKN36861Registered aircraftN36862Linville Keith · Bend, ORN3686BBrosius John W III · Dell Rapids, SDN3686CSedwick William R · Anchorage, AKN3686RNeal Matthhew Z · Mansfield, OHN3686UEnvi Adventures LLC · Troutdale, ORN3686WLadet William D · Las Vegas, NVN3686YEllis Air LLC · Acworth, GAN36877Stilwell Aviation LLC · Stilwell, KSN3687QHjelle Tim D · Malone, WIN3687WBluewater Marine Group Inc · Wilmington, DEN3687ZScott Marilyn F Trustee · Sun City West, AZFirst renewal noticeN36884Main Aviation Inc · Visalia, CAN36885Sky West Aviation Inc Trustee · Albuquerque, NMN36887Aa Aircraft Adventure LLC · Joplin, MON3688CDiedrich Steve A · Sandpoint, IDN3688KFlying Trout LLC · Port Orchard, WAN3688MHammons Clayton W · Salome, AZN3688QFour Musketeers LLC · Wichita, KSN3688RMckay Christopher · Point Arena, CAN3688UTaylor Aviation Inc · Fort Benton, MTN3689CR D Management LLC · Central City, NEN3689PMcaneney Joseph R · Talkeetna, AKN3689QBusick Aviation LLC · England, ARN3689RBdj Farms · Hallock, MNN3689ULeonard Robert E · Mattoon, ILN368BVinnola Bruce L · Glenrock, WYN368BCAugustina Holdings LLC · Argyle, TXN368CDSavfar Aviation Inc · Wilmington, DE
Back to AD 2007-04-19 R1