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.
N66TVDodson International Parts Inc · Rantoul, KSN66UNWillis Robert L · Havana, FLN66VKCummings Michael F Jr · Wellsboro, PAN66WEBurns Gregory A · Newnan, GAN66WHSix Six Whiskey Hotel LLC · Mount Vernon, KYN66WNMeyer Robert J · Canyon, TXN66WWWirstrom Michael N · Corrales, NMN66WYHedrick Kirby L · Cora, WYN66XCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66XEFisher Michael A · Logan, UTN66YEaa Aviation Foundation Inc · Oshkosh, WIN67000Registration Pending · Johns Island, SCRegistration pendingN6700CKelly Aviation & Investigation LLC · Vail, AZN6700FRunels Thomas L · Battle Creek, MIN6700HNashua Flyers Inc · Nashua, NHN67010Robinson Helicopter Company Inc · Torrance, CAN67013Del Ag Aero LLC · Milton, DEN6701JJones Bob J Trustee · Littleton, CON6701NFreeman Alan M · San Antonio, TXN6701PHammond Craig D · Lawton, OKN6701RAirplane And Drone Flight Instruction LLC · Orlando, FLN6701TAtlanta Aviation Academy Inc · Lawrenceville, GAN6701VHub City Aviation Academy LLC · Lubbock, TXN6701ZOsher Air LLC · Wallingford, IAN67022Mccormack James · Mount Jewett, PAN6702DMcwilliams Christopher S · Atlanta, GAN6702HGoetz Terry L · Defiance, IAN6702JWaldron Michelle M · Saranac, NYN6702NRoman Jose Ernesto · Guaynabo, PRN6702PWakefield Robert M · Winnemucca, NVN6702UKruse Benjamin · Phoenix, AZN6702XFlight Time Builders Inc · Memphis, TNN6703SSilverhawk Aviation Academy LLC · Caldwell, IDN6703ZSchneider Aerial Inc · Rugby, NDN6704DScaled Composites LLC · Mojave, CAN6704EWings Over Texas Holdings LLC · Denton, TXN6704JRussell John T · Southaven, MSN6704LSoflo Aviation LLC · Oakland Park, FLN6704NBethel William C · Murray, KYN6705JDuncan William E · Troy, IDN6705NGerback Andrew · East Canton, OHN6706BZvacek Dennis E Trustee · Tulsa, OKN6706HDairy Air Inc · Wyoming, PAN6706NKorn Richard Mark · Lexington Park, MDN6706PHadley George M · Boston, MAN6706YSorbi Aviation Inc · El Cajon, CAN6707HWjt Investments LLC · Gurley, ALN6707MLouis & Clark Aviation LLC · Fort Myers, FLN6707NRegistered aircraftN6707XGromack Stephen · Bloomfield, NM
Back to AD 81-18-04 R2