AD 2022-08-13
Registered aircraft · 3,069
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:2022-08-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-08-13')
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:2022-08-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-08-13') 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.
N151CLAircraft Structures International Corp · Enid, OKN1520QBrekhus Julius P · Kenmare, NDN15210O'Hare R Mike · Clovis, NMN1529ERoth Aerial Spraying LLC · Milford, NEN1529HMiller Aviation Inc · Norton, KSN1529USnider Scott E DBA · Turner, MTN152ALN152al LLC · Tulsa, OKN1531GWoodley Aerial Leasing LLC · Walnut, ILN1531SWakefield Aircraft LLC · Cooperstown, NDN1533SMj Aviation Inc · Walnut Ridge, ARN1539XRba LLC · Kimberly, IDN153GLAlpine Aviation Inc · Provo, UTN153KDMec International Trading LLC · Mission, TXN153PBCarojake LLC · Spartanburg, SCN1540SArthur Aviation LLC · Arthur, NDN1544VGuardian Flight LLC · Lewisville, TXN1547UR & D Leasing Inc · Lemoore, CAN154CAFedair Inc · Indianapolis, INN154CLAircraft Structures International Corp · Enid, OKN154GLAlpine Aviation Inc · Provo, UTN154NPSisk Douglass F Trustee · Oakhurst, CAN1552DDodson International Parts Inc · Rantoul, KSN1552GEast Atlantic Aviation LLC · Edenton, NCN1553GMccloy Mark · Tatum, NMN1556WPrecissi Flying Service Inc · Lodi, CAFirst renewal noticeN15570Shearer Sprayers Inc · The Dalles, ORN15588Slikker Flying Service Inc · Buttonwillow, CAN1558URba LLC · Kimberly, IDN155CJUe-55 LLC · Helena, MTN155CLAircraft Structures International Corp · Enid, OKN155KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN155MCWhite Bay Aviation LLC · Corpus Christi, TXN155SYRocky Mountain Aviation LLC · Aberdeen, IDN155VVVolatile Aero Ventures LLC · Boulder City, NVN157CLSnowy Butte Air Ships LLC · Eagle Point, ORN157HJaars Inc · Waxhaw, NCN157LAWakefield Aircraft LLC · Cooperstown, NDN157MHMile Hi Skydivers Inc · Longmont, CON157STAllen Family Aviation LLC · Haines, ORN158CLUnited States Government · Fort Belvoir, VAN158KQGuardian Angel Homes LLC · Hayden, IDN159CMMomentum Foundation Inc · Tullahoma, TNN160KQMjolhus Knut G · Amarillo, TXN160RWRitch Air LLC · Visalia, CAN160SMAviation Star S LLC · Beaumont, TXN160ZUsda Forest Service · Boise, IDN161KQPenridge Aviation LLC · Portland, ORN162GAPa1 208b-0667 LLC · Fort Lauderdale, FLN162MCBank Of Utah Trustee · Salt Lake City, UTN162QMartin Foundry Service Inc · Glencoe, AL
Back to AD 2022-08-13