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.
N78215Alvarado Eduardo · Fayetteville, TXN78219Testa Christopher · Kennesaw, GAFirst renewal noticeN7821CArmy Knife Enterprises LLC · Oak Hills, CAN7821NStradtner Adam · Laporte, INN7821PTucker Engineering Associates Inc · Locust, NCN78221Waldrop Floyd D · Robinson, ILN78228Lanning Keith L · Everton, ARN7822DTwinco Leasing LLC · Yacolt, WAN7822PTrue Airspeed Aviation LLC · Albany, GAN7822VBarry John J · Bethel, CTN78238Weaver William B · Vancouver, WAN78239Draco Flight School DBA · Chino, CAN7823BBombardo Joseph V · Clermont, FLN7823DBurnopp Jacob A · Evington, VAN7823GAmerican Patrols Inc · Midland, TXN7823HCharley Arrie · Gakona, AKN7823NKaiten Aviation LLC · North Haven, CTN7823VNelson Brent E · Richland, WAN7823WCdm Dirt LLC · Snowflake, AZN78240Kinney Joan M · Vermillion, SDN78242176fps LLC · Marthasville, MON78249Howard Ronald W · Okeechobee, FLN7824CRegistered aircraftN7824DWhitaker Samuel M · Brooklet, GAN7824NMcatarian Mark F · Saint Marys, KSN7824VLyon Timothy P · Kansas City, MON7824WHornbill Aviation LLC · Incline Village, NVN78253Chatman Hannah K · Poplar Bluff, MON78254Bpk Holdings LLC · Montesano, WAN7825LKlause Stephen E · Covina, CAN7825ND&D Vision Air LLC · Aubrey, TXN7825VHenderson Randy G · Williamstown, WVN7825WNelson Aaron D · Carver, MNN7826681 Escadrille Inc · Hutchinson, KSN7826VUse Your Call Sign Holdings LLC · Kalispell, MTN7826YInternational Air Services Inc Trustee · Carson City, NVN7827CKestrel Aviation LLC · Reno, NVN7827DThree Legged Hog Aviation LLC · Boise, IDN7827NBest John P · Goldsboro, NCN7827PRowan Christopher James · Sparks, NVN7827VJaffe Michael R · Terrell, TXN7827WWoods Perry H · Brownsville, TXN7827YEpton Richard Charles · Senoia, GAN7828Lionel Long · Liberty, KYN78286Marsh David J · Sioux Falls, SDN7828DDyer Royal J · Melrose, NYN7828NBurris Jamey E · Mt Juliet, TNN7828PBvv Aviation LLC · Ben Wheeler, TXN7828VHam Henry P · Saint Louis, MON7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OK
Back to AD 81-18-04 R2