AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N704MBBrekke Aerial Service Inc · Edmore, NDN704MRCoco Aircraft Inc · Merritt Island, FLN704NDUniversity Of North Dakota · Grand Forks, NDN704RBAirway Equipment Leasing LLC · Alpharetta, GAN704RTBullwinkel Matthew Allen · Dothan, ALN7050DFoster David S · Justin, TXN7050FCity Of Houston · Houston, TXN7050GAircraft Management Group Inc · Honolulu, HIN7050KSyzygy Consultation Services LLC · Hurricane, UTN7050PBork Joseph L · Mosier, ORN7050QMindy Limited LLC · Muscatine, IAN7050YTonys Aerial Service Inc · Great Bend, KSN7050ZMid Continent Aircraft Corp · Hayti, MON7051State Of Alaska · Anchorage, AKN7051DBraun Ronald J · Wasilla, AKN7051GWein Greggory J · Convoy, OHN7051QBright Flight Aviation Inc · Jacksonville, FLN7051RBest Equipment Leasing LLC · Bakersfield, CAN7052State Of Alaska · Anchorage, AKN7052DMundell Lola Trustee · Rosston, OKN7052FStephens Racquel C · Laguna Niguel, CAN7052GG&H Aviation · Louisville, KYN7052PFlying Great Danes LLC · Chesapeake, VAN7052QHoloman T Michael · New Smyrna Beach, FLN7052RSell Carl N · Spanaway, WAN7052VOut Front Cc LLC · Kalispell, MTN7052WPuskala Thomas S · Iron River, MIN7053Jsrs Holdings LLC · Las Cruces, NMN7053BStevens Alan · Meridian, IDN7053GSpare Change Enterprises LLC · Atlantic, IAN7053KMatlad Inc · Wilmington, DEN7053LVelvick Kathleen R · Peoria, AZN7053PManter Earl F · Delaware, OHN7053QCabrie Aviation Inc · Charlotte, NCN7053WRed Rock Flying School LLC · Mesa, AZN7054State Of Alaska · Anchorage, AKN70541Cl Finney Aviation LLC · Benton, KSN70549Andersen Mark · Huntley, ILN7054BWinter Jerry L · Cumming, GAN7054GSands Aviation LLC · Talking Rock, GAN7054KPehoski Joseph R · Anchorage, AKN7054WLanguage Gert Johannes · Hays, KSN7054YNordman Clay L · Catheys Valley, CAN7055State Of Alaska · Anchorage, AKN70555Hecht Waldo E · Vassar, MIN7055PKehrle Betty M · Chandler, AZN7055QSeagraves Brad J · Rockwell, NCN7055RRegistered aircraftN7055WRickard Donald L · Rowland Hts, CAN7056State Of Alaska · Anchorage, AK
Back to AD 81-18-04 R2