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.
N9654BDonohue Andrew · Tulsa, OKN9654JMouton Charles J Jr · Gladewater, TXN9654QFly Pioneer Valley LLC · Gill, MAN9654URealty Investment Co Ltd · Hilo, HIN9654VN9654v LLC · Lakeland, FLN96558Baxter Daniel D · Lake Oswego, ORN9655JDunn James Blair Jr · Bumpass, VAN9655MJarco Group LLC · Lititz, PAN96567Gmt Aviation LLC · Newtown, CTN9656DSpearman Clint · Scottsbluff, NEN9656JVolpe Robert · Holiday, FLN9656MWashington Aviation Inc · Seattle, WAN9656PLee Gerald R · Glennallen, AKN9656QMccort Daniel R · Pensacola, FLN9656RGlenn Jeff P · Billings, MTN9656ULanglois Zachary J · Deerfield, NHN96573Condor Aero Club Inc · Zelienople, PAN96574Baxter David C · Saint Helens, ORN96575Biryukov Ruslan B · Encino, CAN96576Baxter David C · Saint Helens, ORN96579Civil Air Patrol Inc · Maxwell Afb, ALN9657LLongobardi Vito A · Westport Island, MEN9657PJacobsen Nathaniel · Juneau, AKN9657SWhite Wayne A · Scenic, SDN9657VChorman Spraying LLC · Milton, DEN9657WNorth Stephen P · Rochester, NYN9658DSwann Sherrie Kim Trustee · Toledo, OHN9658FFerguson William T · Fayetteville, TNN9658KFlying Particles Inc · Livermore, CAN9658MReames B Robert Jr · Six Lakes, MIN9658URegistration Pending · Spencer, NERegistration pendingN9658WGraham Joel A · Marietta, GAN9659AAugust Aero LLC · Kalispell, MTN9659HJd Griffin LLC · Wilmington, DEN9659KBell Michael J · Duck Key, FLN9659LMoffatt Thomas · Dallas, GAN9659QMacrafic Bruce A · Garden City, MNN9659SRandall Timothy J · Skidmore, MON9659WMitchell Matthew · Ypsilanti, MIN965AAWings Over Texas Holdings LLC · Denton, TXN965ACNaples Air Center Inc · Naples, FLN965AUAuburn University · Auburn University, ALN965BBBascom Kimber Keith · Mckinney, TXN965CCannon Travis H II · Corinth, TXN965CPCivil Air Patrol · Maxwell Afb, ALN965CWAir Capital Aviators Club · Wichita, KSN965CZStadler Frederic L · Oshkosh, WIN965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN965JRichardson Cotton Inc · Wilmington, DEN965JBKeevair LLC · Rockaway, NJ
Back to AD 81-18-04 R2