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.
N6894WSummit Flight Academy LLC · Peculiar, MON68954Wings Over Texas Holdings LLC · Denton, TXN68956Spartan Education LLC · Tulsa, OKFirst renewal noticeN6895DPw Air LLC · Rockingham, VAN6895KRiemer Emil F · Brush Prairie, WAN6895NLadd Noel Joseph Espinosa · Edmond, OKN6895PDavis Jack J · Rifle, CON6895UWoodward Jeffery F · Viroqua, WIN6895WSale Reported · Brighton, COSale reportedN68961Shouling & Philip Enterprise · Lancaster, CAN68963University Of Michigan Flyers Inc · Ann Arbor, MIN6896HBuiqui Aerospace Corp · Kissimmee, FLN6896NHarding Ronald D · Spokane, WAN6896PHwang Andrew S · Emeryville, CAN6896SSullivan Leo W · Ofallon, ILN6897BCape May Aerial Advertising LLC · Cape May Ch, NJN6897CSchumann Donald A · Naperville, ILN6897UStyer David B · Pendleton, ORN6897WMcdowell Robert D · Snohomish, WAN68980Connected Aviation LLC · Peoria, ILN6898HS J Holding LLC · Wilmington, DEN6898NMcdonald John A · Dublin, OHN6898PWeigle Alan B · Seward, NEN6898WSarah Business LLC · Wilmington, DEN6899FLevel Up Aviation LLC · Newton, ALN6899NStearns Lloyd Bernard · Georgetown, TXN6899RDavenport Henry B IV · Berryville, VAN6899UMayo Clayton E · Ten Mile, TNN689AW Grotendiek LLC · Portland, ORN689BTDoell Brad J · Elsie, NEN689CPCivil Air Patrol · Maxwell Afb, ALN689ENafsinger Nicholas A · Rosharon, TXN689JATextron Aviation Inc · Wichita, KSN689LHChristiansen Aviation LLC · Wilmington, DEN689MAN28179 Inc · West Gilgo Beach, NYN689NDUnd Aerospace Foundation · Grand Forks, NDN68ACSchgallis Richard J · Gainesville, VAN68ADMorgan Edward J · Murchison, TXN68AGDelucia Dennis DBA · Franklin, PAExpired dealer, pending cancellationN68AH740 Assoc Inc · Wilmington, DEN68BAllen April E · Green Cove Springs, FLN68BDBuiqui Aerospace Corp · Kissimmee, FLN68BEAir Pro Aviation LLC · Cross Lake Twp, MEN68BLPhillipson Justin M · Vacaville, CAN68BWRegistered aircraftN68CAAsset Management Advisors Corp · Plantation, FLN68CNEichten Steve G · Colleyville, TXN68CSTrojen Properties LLC · Joplin, MON68DBLai LLC · Flowood, MSN68DEMazzoni Dennis · Mays Landing, NJ
Back to AD 81-18-04 R2