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.
N9PASteckner Michael · Beachwood, OHN9PBUnderwood David G Trustee · Naperville, ILN9PEN9pe LLC · Locust Grove, GAN9PMNdlebe Isabella L · Okemos, MIN9PTDonnelly Mark J · Newborn, GAN9QAVerwolf Phil A · Broadus, MTN9QBNorthern Aviation LLC · Palmer, AKN9QYAmelia Air LLC · Naples, FLN9RFSkinner Norman D · Osceola, IAN9RXKovach Kim A · Ocala, FLN9SVPaul Guy M · West Columbia, TXN9TARhynette Airways LLC · Key Largo, FLN9TSRegistered aircraftN9TZHarfst Michael · Milwaukie, ORN9UFElliott Michael R · Friendswood, TXN9VGOak Tree Title Of Oklahoma LLC · Oklahoma City, OKN9VTWarren Keith · Delta Junction, AKN9VVAviation Museum At Garner Field Inc · Uvalde, TXN9VXLillie Bruce · Orlando, FLN9WDAngle Matthew · Teton Village, WYN9WKRegistration Pending · Paradise, TXRegistration pendingN9WPMclamore S Whitman · Tampa, FLN9WUHartman Matthew F · Billings, MTN9WZDiesel Doctors Of Lake City Inc · Lake City, FLN9XER A F S LLC · Reno, NVN9XFBounds Keith A · Thomson, GAN9XJMontgomery Flying Club Inc · Montgomery, ALN9XKLandrum Kelly Thomas · Halifax, VAN9YACross Tom W · Redding, CAN9YVChampness Daniel N · Bakersfield, CAN9YZTwo-Two-Uniform Club Inc · Oxnard, CAN9ZAStella Company LLC · Boyce, VAN9ZUFowler Ronald W · Lopez Island, WA
Back to AD 81-18-04 R2