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.
N9672JRoger Dodger Vector Victor LLC · Fort Myers, FLN9672KEverglades Aviation Academy LLC · Weston, FLN9672UKelley Christopher M · Gilbert, SCN9672VAirline Transport Professionals Corp Of USA · Wilmington, DEN9673JTamke Jon A · Battle Lake, MNN9673VTaylor Charles E · Killdeer, NDN9674DSpace Coast Aircraft Co · Merritt Island, FLN9674KLambert Dwight · Albany, ORN9674PTexas Dakota Partners Ltd · Rankin, TXN9674TMichael Guetersloh · Sandia, TXN96751Dsr Cherokee 180 LLC · Dallas, TXN9675CRegistered aircraftN9675LGunter Parnie L Jr · Watauga, TXN9675MDkml Aviation LLC · Celebration, FLN9675PMiller Judith A · Homer, AKN9676CNot A Jet Yet LLC · Molalla, ORN9676JOligario Jeremiah J · Fayetteville, NCN9676KEjs Enterprises LLC · Incline Village, NVN9676LGordon Clyde B Jr · Westerly, RIN9676PLoose Jason G · Harlowton, MTN9676URedwood Aircraft LLC · Santa Rosa, CAN9676VCronsell Christopher A · Muskego, WIN96775Christiansen Aviation LLC · Wilmington, DEN9677MRoberts Eric · College Place, WAN9677QKodiak Flying Club Inc · Kodiak, AKN9677UPierce Jeff · Henrietta, TXN9678Clark Steven R · Dade City, FLN96788Lewis Garry L · Livingston, LAN9678HBuckles Edward W II · Mechanicsburg, ILN9678JNegley Neil C · Newburg, PAN9678MAire Matt Inc · Pequot Lakes, MNN9678PSvancara Ty Robert · Moses Lake, WAN9678QNorthgate Aviation Inc · Chico, CAN9678WDependable Aviation LLC · Cartersville, GAN96792N96792 LLC · Shrewsbury, MAN9679AEquinoxx Flight Systems LLC · Lawrenceville, GAN9679LGo Fast Dont Suck LLC · Magnolia, DEN9679MIngalls Brian E · Lancaster, CAN9679PAnderson Kevin L Trustee · Big Lake, AKN9679QEagle Sky Patrol Inc · Deadwood, SDN9679SBistline John A · Cedar City, UTN9679UThorn Eric Miller · Arlington, VAN9679WDnr Solutions LLC · Idaho Falls, IDN967AAWings Over Texas Holdings LLC · Denton, TXN967CMDonaldson Charles A · Clay City, KYN967CPCivil Air Patrol · Maxwell Afb, ALN967EYJoy Ventures LLC · Helena, MTN967GAtp Aircraft 9 LLC · Wilmington, DEN967JRAmoroso Ricardo C · Powder Springs, GAFirst renewal noticeN967LTUniversity Of La System DBA · Ruston, LA
Back to AD 81-18-04 R2