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.
N7391YAeronautical Technical Service Inc · Collierville, TNN73922Mouton Charles J Jr · Gladewater, TXN73923Professional Aviation Aircraft Services Ltd · New Philadelphia, OHN73924Mack Aviation Holdings LLC · Atlanta, GAN73925Wings Over Texas Holdings LLC · Denton, TXN73926Hatanaka Brandon C · Loveland, CON73927Abcd Ventures LLC · Ada, OKN73928Air Peanut Ltd · Wilmington, DEN73929Jprg Aviation Inc · Orlando, FLN7392J33 Global LLC · Potomac Falls, VAN7392LKnowles Charles M Jr · Chapmanville, WVN7392PGray Matthew R · Haymarket, VAN73930Bunke Paul R Trustee · Harrison, OHN73934Hanson Alexander P · Bremerton, WAN73938Preston Richard R Trustee · Albuquerque, NMN7393GBlue Wings LLC · Brecksville, OHN7393JSale Reported · Tyler, TXSale reportedN7393ZDrennan Monte D · Caddo, OKN73946Carastro Enterprises LLC · Montgomery, ALN7394PWhittle Mark A · Crestview, FLN7395DAviation Management Group LLC · Endicott, NYN7395GBrewer James · Myakka City, FLN7395JOhm Aviation LLC · Wmca, NVN7395KDoty Brandon Charles · Debary, FLN7395LCatherines Aviation Services LLC · Sewanee, TNN7395PGroux Jeffrey S · Rome, GAN7395WHuckfeldt Owen D · Alliance, NEN7395XBrl Air LLC · Onsted, MIN73964Coachron Investments LLC · Grosse Ile, MIN7396JBurns Preston T · Spruce Pine, ALN7396WN7396w LLC · Coeymans Hollow, NYN7396YAllen Charles M · Puryear, TNN73977Bfl Aviation LLC · Bakersfield, CAN7397BAerolina Inc · Hendersonville, NCN7397GMarkowitz Edwin P · Luray, VAN7397JJmk Repair · Lone Oak, TXN7398Weston Weed Control LLC · Weston, WYN73981Gagnon Michael J · Merrimack, NHN7398JGreat Lakes Aviation Services LLC · Kimball, MIN7398LNelson Gregory J · Newcastle, CAN7398WJil Aviation Inc · La Coste, TXN7399JGordon Jacob M · Tega Cay, SCN7399PPache Keith M · Montgomery, TXN7399WI Was Inverted LLC · Fort Myers, FLN739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeN739AFSilver Isaac M · Satellite Beach, FLN739AGS O W Aviation LLC · Crystal River, FLN739AJAviation Adventures LLC · Billings, MTN739AKChen Wu · West Windsor, NJN739AMBartels Michael · San Antonio, TX
Back to AD 81-18-04 R2