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.
N69CZVermeylen John B · Altamont, TNN69DASwanson Brian W · Mount Morris, NYN69DLIndy Air Sales LLC · Anderson, INN69DSSale Reported · Tomball, TXSale reportedN69DYJohnson Christopher · Tulsa, OKN69ETSale Reported · Nampa, IDSale reported, pending cancellationN69FLFlx Holding Co LLC · Boca Raton, FLN69GSDaphnee Moise Md Pa · Sarasota, FLN69HANorth County Flying LLC · North Palm Beach, FLN69HHTaylor Kent M · Crawford, COFirst renewal noticeN69HSPofahl Steven R · Brookings, SDN69HUMe Time LLC · Denver, CON69JBIsburgh Andrew N · Conyers, GAN69JCBlomquist Randall J · Cave Creek, AZN69JDPrivate Aero LLC · Sarasota, FLN69JTGranger Daphne · Pearland, TXN69JVRasch Hellmut G · Tomball, TXN69KCShipner Robert W · Palatine, ILN69KPBurns Justin J · Bend, ORN69KVNichols James D DBA · Williamson, GAN69KWWeeks Kermit A · Polk City, FLN69KYAircraft Guaranty Corp Trustee · Oklahoma City, OKN69LMMaynard Larry · Alpharetta, GAN69LNValiair Limited Co Trustee · Casper, WYN69LPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN69MFSix Ten Ventures LLC · Grand Prairie, TXN69MGArizona Active Air LLC · Yuma, AZN69MJKerr Peter John H · North Charleston, SCN69MLArnold Thomas S · Saint Augustine, FLN69MWOlson James H · Eleva, WIN69NDShannon Christopher R · Nome, AKN69NNRoadrunner Contraptions LLC · Azle, TXN69NSAircraft Guaranty Corp Trustee · Oklahoma City, OKN69PAWanagel Joshua · Berwyn, PAN69PDDemray William S · Northville, MIN69PZParagon Airplane Leasing Co · Fort Myers, FLN69RDKrens Janet E · Purcellville, VAN69RJSilver Blades Inc · Wilmington, DEN69RMDicicca Yolanda L · BitontoN69RNLeong Peng H · Sebastopol, CAN69RRInternational Air Services Inc Trustee · Carson City, NVN69RXFlying W Aviation LLC · Aurora, CON69SXShuck Michael W Trustee · Maize, KSN69TUD & G Aero LLC · Lomita, CAN69TWHiemstra Andrew · Tuolumne, CAN69TZUnder The Radar LLC · Henderson, NVN69ULRed Rock Flying School LLC · Mesa, AZN69VPPotts Vince L · Dothan, ALFirst renewal noticeN69WJBahn William L · Jackson, MON69WLPhillips Aviation · Port Orange, FL
Back to AD 81-18-04 R2