AD 80-25-07 R1
Registered aircraft · 25,369
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N66VSEurovation Inc Trustee · KematenN66WSDighans Murray · Peerless, MTN6700HNashua Flyers Inc · Nashua, NHN6700PAbraham Curtis · Byron, WYN6701NFreeman Alan M · San Antonio, TXN67022Mccormack James · Mount Jewett, PAN6702HGoetz Terry L · Defiance, IAN6702NRoman Jose Ernesto · Guaynabo, PRN6702UKruse Benjamin · Phoenix, AZN6704EWings Over Texas Holdings LLC · Denton, TXN6704NBethel William C · Murray, KYN6705NGerback Andrew · East Canton, OHN6706HDairy Air Inc · Wyoming, PAN6706NKorn Richard Mark · Lexington Park, MDN6707HWjt Investments LLC · Gurley, ALN6707NRegistered aircraftN6708UBlaedow Kyle R · Leesville, LAN6710NJohnson Kenneth W · Pine Bluff, ARN6710UMonroe Flying Club Inc · Glen Carbon, ILN6711NHanna William R · Castle Rock, CON6711UUlassin Kyle B · Corvallis, ORN6712USchell Kerry A · Arvada, CON6713UHinds Casey L · Seattle, WAN6714NLawler Thomas W Jr · French Lick, INN6715NWomble Phillip A · Enid, MSN6716NAmyett Stanley B · Brady, TXN6716UPickworth Jonathan · Philadelphia, PAN6717EDenrow Limited Lc · Shawnee, OKN6717NGaskill David E · Toledo, WAN6718NHoefly Christopher S · Belleview, FLN6718UBerra Robert J · Burtonsville, MDN6719URegistered aircraftN671DBThomas Andreas P · Bend, ORN671RMKapp Florian C · Lagrange, KYN671SAKuhn Ent Inc · Manilla, INN6720NWatson Andrew J · Chelmsford, MAN6720UGilt Michael F · Raleigh, NCN6722NShipman Jesse L · Honey Grove, TXN6723UHohn Jeffrey A · Townville, SCN6725NB Ryan Enterprises Inc · Lynnfield, MAN6726NBritsch Uwe K DBA · Klamath Falls, ORN6727HAldora Enterprise LLC · League City, TXN6727NCroney Mark J · Lawrenceville, GAN67282Grandy Boyd · Arcadia, CAN67286Mars Aerospace Inc · Bay Shore, NYN67289Cosklo Ronald J · Fell Township, PAN6728UReed Walter D · Lahoma, OKN67292Mock Joseph R · Huntsville, TXN6729NAnderson Douglas E · Winchester, ORFirst renewal noticeN672FCBlackhawk Holding Corp · Wilmington, DE
Back to AD 80-25-07 R1