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.
N713VSJrr Professional Services LLC · Davie, FLN713WS&D Hangers · Galveston, TXN713WKLegends Air Center LLC · Bentonville, ARN713XHenderson James Allen · Flomaton, ALN713ZHanten Michael A · Bremerton, WAN71404N457jh LLC · Meridian, IDN71409Piedmont Flight Inc · Winston Salem, NCN7140BEstep James B · Chillicothe, OHN7140DRiedeman Thomas D · Genoa, OHN7140JCohesive Aviation LLC · Gilford, NHN7140KChandelle Ltd · Brighton, CON7140LK Anthony Lax Aviation LLC · Mount Pleasant, SCN7140QMagnuson Jessica M · Olathe, KSN7140RJohnson Douglas W · Grand Forks, NDN7140TMurray Robert S Trustee · Shingle Springs, CAN7140VVallejo Noel R · Alpine, UTFirst renewal noticeN7140WDevers Malcolm W · Norwood, NCN7141BPatterson Brent E · East Aurora, NYN7141CLongview Iron LLC · Longview, TXN7141GDyke Paul A · Hartford, SDN7141LWamar Enterprises LLC · Eureka, MON7141PWild Aire LLC · Wilmington, DEN7141QFlight Time Builders Inc · Memphis, TNN7141RAyars Dean P · Punta Gorda, FLN7141UBlazevic Bojan · Las Vegas, NVN7141WWest Richard R · Meridian, IDN7142DHarper Michael E · Cloquet, MNN7142FMarble Jere D · Dayton, NVN7142KHogan Mark C · Bend, ORN7142LEshuis Hermannus A · Lake City, FLN7142PCorbets Jeffrey B · Santa Clarita, CAN7142QObymachow Richard M · Killingworth, CTN7142UBykowsky Eric · Atlanta, GAN7142VTarantino Joseph A · Daytona Beach, FLN71431Klele John M · Midland, MIN7143FKnoth Kurt A · Grand Haven, MIN7143GAllen Nathanael W · Bemidji, MNN7143PKc Flyers Inc · Wilmington, DEN7143RWertz Travis F · Richland Center, WIN71444Rushville Flying Club Inc · Rushville, ILN7144DRichardson James G · Fremont, CAFirst renewal noticeN7144GJc Flight Inc · Wilmington, DEN7144LN7144l LLC · Sealy, TXN7144PAllis Frederick M · Eden Prairie, MNN7144RSkyview LLC · Omaha, NEN7144VJs&J Enterprises LLC · Sapulpa, OKN7144WDornink Kent · Preston, MNN7145KBurg Robert L · Fairbanks, AKN7145NOklahoma Beech Boys LLC · Weatherford, OKN7145PAstraeus Lc · Evanston, WY
Back to AD 81-18-04 R2