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.
N789WTGabrys Ronald B · Wisconsin Rapids, WIN78AHCenturion Aviation LLC · Virginia Beach, VAN78AJHamlin Curits · North Pole, AKN78AKFreytag Ronald D · Stockton, CAN78ATSchrage Rodney L · Steamboat Springs, CON78BGKdrd Holdings LLC · Texas City, TXN78BKKang Byung · Kansas City, MON78BYNorthwestern Michigan College · Traverse City, MIN78CWPotter Justin D · Eagle River, AKN78DFBurkett Robert S · Baytown, TXN78DJKing David V · Mars, PAN78DLBruns Luke · Flower Mound, TXN78DRWhitehead Michelle W · Centralia, WAN78DWNeu Lawrence R · San Antonio, TXN78EFFearnow Rolland E · Wabash, INN78FMFraker Gregory M · Plymouth, MIN78GCMh Aviation LLC · Foster City, CAN78GPBailey Eric C · Lake Havasu City, AZN78GTBennett Wayne M Jr · Puyallup, WAN78HBValiair Lc Trustee · Casper, WYN78HYD A Lamont Public Adjusters LLC · Springtown, TXN78JDArtigas Gonzalo J · Cambridge, MAN78JFRace39 LLC · Kenmore, WAN78JHPlane Fun Inc Tr Trustee · Snellville, GAN78JMDye William M · Atlanta, GAN78JNMuseum Of Flight Foundation · Seattle, WAN78JRFocus Air LLC · Wilmington, DEN78JSJet South LLC · Medford, NJN78KPYoungblood Dennis L · Crystal River, FLN78KVShore Dog Aviation LLC · Dover, DEN78LLLawnchair Pilots Association LLC · Wilmington, DEN78LSNor-Cal Air LLC · Kalispell, MTN78MJTalley Patricia · Asheboro, NCN78MTBrady William P · Banner, WYN78MUKoonce John P · Jefferson City, MON78MVWhittington Rankin A Trustee · Lenoir, NCN78NJBessie Aviation LLC · Lexington Park, MDN78NPHeaton Justin · Lufkin, TXN78NSRobertson Lester M · Hamilton, OHN78PDBryant Jerry L · Punta Gorda, FLN78PJRothrock John W Jr · Danville, INN78PLDunaway Dennis G Jr · Port Orange, FLN78PPToman Gregory R · Caledonia, MIN78PWPower Joe D · Seguin, TXN78QBPandion Aviation LLC · West Chester, PAN78QPHilyer Bruce W Trustee · Seattle, WAN78RFFairchild Maxwell D · Morristown, TNN78RGBubber Inc · Lake Providence, LAN78RJUsaeroflight LLC · Greenville, SCN78RLDavis Murray L · Fair Play, CA
Back to AD 81-18-04 R2