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.
N7683DYellow Bird Inc · Doral, FLN7683FFisch David S · Leland, NCN7683GBalgoyen James T · Charlotte, MIN7683HNovember Alpha LLC · Dover, DEN7683KArne Blair · Carpenter, SDN7683PCavel Lonnie R · Vidor, TXN7683SSzabolscky Stephen L · Remington, VAN7684DRegistration Pending · Destin, FLRegistration pendingN7684FLettunich Mitchell C · Newcastle, CAN7684HWellborn Ralph L · Kenai, AKN7684PPache Keith M · Montgomery, TXN7684SStrehle Scott · Lewiston, IDN7685DMcdonnell Chris M · Naknek, AKN7685MLazy Double Air LLC · Bloomer, WIN7685PPinkel Lawrence W · Albuquerque, NMN7685SHull Kevin G · Sadler, TXN7685YNehrbass Douglas J · Clarksville, TNN7685ZHigh Flights Soaring Club Inc · Peyton, CON7686FBaremor Terry A · Brooklyn Park, MNN7686HTotal Flight Aircraft Leasing LLC · Apex, NCN7686JCovic Craig A · Cordova, TNN7686WEcho Aviator LLC · Whitehouse, OHN7686YMontana Leasing Group LLC · Park City, UTN7687MMckown Kevin · Edgewood, NMN7687RTaylor Edward P Jr · Spanishburg, WVN7687SLynn Robert W · Independence, WVN7688CCable Bradley D · Indianapolis, INN7688DMiller Gregory B · Wasilla, AKN7688HHersrud John D · Wasilla, AKN7688JClapp Rollyn D · Volga, SDN7688LConsag LLC · Ainsworth, NEN7688RTrudeau Lemaster Productions · Woodland Hills, CAN7688SJohnson Brian G · Goodridge, MNN7688WBurns Joyce A · Sparta, MON7689GMerrihew Jerry R · Ashby, NEN7689RDelehant Edward J III · Keller, TXN7689YGitlow Stuart · Woonsocket, RIN768AMeridian Aircraft LLC · Wilmington, DEN768ACBowe Joseph E · Ocklawaha, FLN768AZStinker Air LLC · Reno, NVN768CStieren George L · Kerrville, TXN768CACollet Mark · Plymouth, MAN768FAnderson William Keven · Mc Gregor, TXN768GASumner Gary · Knoxville, TNN768KAFrizzell Alex A · Auburn, ALN768LBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN768NDUniversity Of North Dakota · Grand Forks, NDN768SHHoffman Stephen A · Hereford, TXN768SPLast Sea LLC · Saint Augustine, FLN768TPjd Holdings LLC · Grand Blanc, MI
Back to AD 81-18-04 R2