AD 81-13-10 R1
Registered aircraft · 4,001
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-13-10-R1')
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-13-10-R1')
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-13-10-R1') 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-13-10-R1') 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.
N76XPCag Interional Inc DBA · Longmont, CON770CBTeton Avjet LLC · Driggs, IDN770CDCunningham Campers & Rvs · Clarksville, INN771PMaxq Composites LLC · Oxford, MEN771SMGilbreath Tony C DBA · Olustee, OKN7724CBiedenharn John D · Sunset Beach, CAN7724THedding/Neff Aviation LLC · Moore, OKN7728ALynch James Kevin · Forsyth, GAN772KWTime Flies LLC · Loxahatchee, FLN772MABaumbaugh Randal Kelly · Granger, INN772MVAir And Sea LLC · Oak Bluffs, MAN7734ZWollert Aircraft Sales · Wiley, CON773TMSouthern Mooney Inc · Wilmington, DEN7742GEmmons Michael R · Temple, TXN774CHigear Aviation LLC · O Fallon, MON7751LU S Air Force Owner · Beale Afb, CAN7752LUnited States Airforce Owner · Albuquerque, NMN7753LUnited States Air Force · Usaf Academy, CON7754LUnited States Air Force · U S A F Academy, CON77551Otto Robert E · Battle Ground, WAN7755LUnited States Air Force · U S A F Academy, CON7756LUnited States Air Force · U S A F Academy, CON7757LUnited States Air Force · Usaf Academy, CON775JDPolakewich Gerald F · Biddeford, MEN7764CJrh Trading LLC · Grapevine, TXN776MFBering Capital LLC · Anchorage, AKN7770LEiler Donald L · Des Moines, WAN777CD777cd LLC · Rochester, MNN777HEUsoarflorida LLC · Fort Myers, FLN777JDFwm Aviation Inc · Washington, DCN777MBCullen Maryrose · Longmont, CON777MDMateusz Dziuda · CambridgeN777MTNortheast Cub LLC · Hudson, NYN777NDFreed David · Santa Barbara, CAN777SNInternational Air Services Inc Trustee · Carson City, NVN777TWMcdonald Timothy J · Daytona Beach, FLN777VYBloomfield Management Inc · Dodgeville, WIN7788TIn Motion Aviation Group LLC · North Hollywood, CAN779CDHiatt John Trustee · West Des Moines, IAN77AHPate Steven H · El Paso, TXN77CMRegistered aircraftN77DNGrant County Mosquito Dist #1 · Moses Lake, WAN77ENEuroaviation Inc Trustee · KemtenN77FTCapeplane LLC · Cape May, NJN77KPInformation Softworks Inc · Ann Arbor, MIN77SZMermoz Inc Trustee · Wilmington, DEN78006Johnson Mildred J Executor · Boerne, TXN78037Bartholomew Don · Gardnerville, NVN78056Plane Fun Inc Tr Trustee · Snellville, GAN78057Hampton Gerald N · Cameron Park, CA
Back to AD 81-13-10 R1