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.
N5783HBellas Bryan T · Geneva, OHN5783ULindberg Kyle J · Pahrump, NVN5783WDillard Joseph · Thaxton, MSN5783ZAlix Brian R · Valley Falls, NYN5784FCrocker James Fuller · Trussville, ALN5784HWright William J · Raeford, NCN5784PMiller Jeffery Allen · Menifee, CAN5784QArias Raymond G · Wesley Chapel, FLN5784UMchenry Charles · Siloam Springs, ARN5785LVance Marc G · Canal Winchester, OHN5785PSmith Clyde R Jr · Lock Haven, PAN5785QSw Industry Inc · Wilmington, DEN5785UZanino James A · Sterling, MAN5785WLilu LLC · Siloam Springs, ARN5786FPalazzi Michael A · Longmeadow, MAN5786HLynn Leroy D · New Carlisle, OHN5786PMckowan Sheila R · Chatsworth, CAN5786QMartinez Todd P · Vacaville, CAN5786UCampbell Ashley H · Colorado Springs, CON5786WPowers Meranda M · Nampa, IDN5787BWilliams Thomas C · Fort Myers, FLN5787DWyoming Development LLC · Cheyenne, WYN5787HLagace Donald O · Augusta, MEN5787UCodreanu Octavian · Thorndale, PAFirst renewal noticeN5787WNewsome Robert K · Linwood, NCN5787ZFaust David E · Windber, PAN5788HMillar George B · Le Claire, IAN5788QMccabe David P · Tower, MNN5788WTech Flight Corp · South Hamilton, MAN5789DTripacer Bretheren LLC · Longview, WAN5789FKarnegis Frank J · Senoia, GAN5789HBlumer Charles · Fullerton, CAN5789PNiche Pharmaceuticals LLC · Shorewood, MNN5789QWayden John R · El Paso, TXN5789WLewandowski Robert G · Crestwood, KYN578BWBridgewater State University · Bridgewater, MAN578CAChristiansen Aviation LLC · Wilmington, DEN578FLChapin William C · Jackson, MIN578GVGrant Aviation Inc · Anchorage, AKN578KAtp Aircraft 3 LLC · Wilmington, DEN578KSMisurelli Francis X · Lake Hopatcong, NJN578MCChristiansen Aviation LLC · Wilmington, DEN578QWWhelchel Leon · Vinton, IAFirst renewal noticeN578RVGembala Gary L · Strongsville, OHN578SCSpartan Education LLC · Tulsa, OKN578ZAAviat Aircraft Inc · Afton, WYN5790DJohnston Jeff · Edgewood, NMN5790FRenner Thomas F · Chandler, AZN5790LSeveca Ventures LLC DBA · Arcola, TXN5790QSurman Stephen · Draper, UT
Back to AD 81-18-04 R2