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.
N900SDSpot Aviation Ltd LLC · Wilmington, DEN900TFStahl Toby K · Roundup, MTFirst renewal noticeN900TXWilliams Harry · Summerland Key, FLN900USSawyer Christopher William · Pensacola, FLN900WDPotter Sherrie L · Temple, TXN900WMMiddlebrook William · Penn Yan, NYN900WWBucher Burton · North Chicago, ILN900YShadick Roger R · Eagle River, WIN900YSInternational Air Services Inc Trustee · Carson City, NVN9010DGriffin Roger P · Port Clinton, OHN9010JNix Terry W · Golden, MSN9010KMitchell Richard · Voorhees, NJN9010WThibodeaux David J · Anna, TXN9011LLussier John A · Greene, RIN9011WKrauser Peter · Saint Petersburg, FLN9012HLeading Edge Flight Academy LLC · Bend, ORN9012WPolybrown LLC · Massapequa, NYN9013DDemmler Brian D · Ocean City, MDN9013KSimpson Craig S · Nikiski, AKN9013LBarbee Lisa · Dallas, TXN9013WGrana Leonardo Javier · Huntersville, NCN9014HFlex Air Holdings Inc · Manhattan, KSN9014PSherback Michael A · Mountain View, CAN9015LMalone Aaron E · Wasilla, AKN9015NPerry David · Campbell, CAN9015USwan John H · Anchorage, AKFirst renewal noticeN9015VAarow Aircraft Leasing LLC · Mcminnville, ORN9016PRegistered aircraftN9016YStevenson William E · Sutton, AKN9017DGamertsfelder Joe · Midland, TXN9017HMeece Harvey T · Somerset, KYN9017JHarlan Tom L · Bakersfield, CAN9017WHyde Charles G · Roanoke, TXN9018DPhillips Melvin · Clarksburg, MDN9018LJones Dwight D · Anchorage, AKN9018WPatzell Curtis J · Mandan, NDN9019DSale Reported · Cave Creek, AZSale reported, pending cancellationN9019EBelson Joseph Victor · Bellevue, WAN9019PReeves Robert Lincoln · Charlotte, NCN9019QSyrasoft Aviation LLC · Baldwinsville, NYN901AArcher Aero LLC · Wilmington, DEN901APEvanson Scot A · Monroe, TNFirst renewal noticeN901BBVisual Group Inc · Tampa, FLN901CCKrizanich Richard K · Anacortes, WAN901CPCivil Air Patrol Inc · Maxwell Afb, ALN901EHigh Five Flying LLC · Amarillo, TXN901FCSkyborne Airline Academy Inc · Vero Beach, FLN901GDAir Charter Inc DBA · Culebra, PRN901HRKcsi Aerial Patrol Inc · Bakersfield, CAN901JWings Over Texas Holdings LLC · Denton, TX
Back to AD 81-18-04 R2