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.
N554Valiair Lc Trustee · Casper, WYN55401Keesling Roger · Starkville, MSN55402Gleason Scot · Hayden, IDN55404Atlanta Aviation Academy Inc · Lawrenceville, GAN55407Yeager Bradley William · New Market, ALN5540JLesser Antilles Corp Trustee · Wilmington, DEN5540KTymczyszyn William R · Torrance, CAN5540UEvans Thomas Patrick · Hollow Rock, TNN5540WAir-Crete Constructions Inc · Lake Elmo, MNN55414Macair Aviation LLC · Xenia, OHN55416Cox David S · Elizabethtown, KYN55419Kinneberg Russell · Plymouth, MNN5541MDistrict School Board Of Pasco County · Land O Lakes, FLFirst renewal noticeN5541URegistered aircraftN5541WKauffman Duane N · Sarasota, FLN5541ZSpivey Harold E · Thomaston, GAN55420M A R S Aircraft Leasing LLC · Williamsburg, VAN55421Burton Tucker · Moberly, MON55422Boardman Thomas M · Greenwich, NYN55423Prescott Flying Club Inc · South Saint Paul, MNN55424Delgado LLC · Brandon, VTN55428Flight Gear Aviation LLC · Pickerington, OHN5542FColtman Graham E · Colleyville, TXN5542WAdvanced Airplanes Associates Inc · Keller, TXN55433Thrasher Aviation LLC · Bartonsville, PAN5543EMedina Kevin S · Glendale, CAN5543FPantelias George · Astoria, NYN5543KClassic Aviation LLC · Richmond, MIN5543TTrinidad Flyers LLC · Fort Meade, MDN5543UAckerman Richard K · Ponce De Leon, FLN5543WTerpe Roberto Palomera · Sedro Woolley, WAN5543ZKiendl Philip R · Carabaset Vly, MEN55441Airide Enterprise LLC · Dixon, MON55449Syracuse Flight School Inc · Syracuse, NYN5544KZollars Thomas B · Dallas, TXN5544LRegistration Pending · Troy, NYRegistration pendingN5544SLobitz James R Co Trustee · Oak Park, CAN5544TPercario Joseph · Warren, NJN5544WMatlack Mark R · Saint Bonifacius, MNN5544ZBetween The Seams Inc · Locust Grove, GAN5545Javelo LLC · Ash Flat, ARN55450Conway Global LLC · Groom, TXN55452Schroeder William L · Sarasota, FLN55457Legend Air Lease LLC · Hurricane, UTN55458Challenger LLC · Amston, CTN5545BLundsted Andrew S · Taylor Falls, MNN5545JMouat Michael Wayne · Hemet, CAN5545KSchroder Bernd · Brownsville, CAN5545LRegistered aircraftN5545MMata Brian J · Sacramento, CA
Back to AD 81-18-04 R2