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.
N7138PHickman Marcus · Fort Worth, TXN7138RFleahman Colton · Woodlawn, TNN7138UHinkle Robert J · Caldwell, IDN7138VColombo Brian M · Oswego, NYN7138WBazal Jared · Castle Rock, CON7139GSkysg LLC · Eugene, ORN7139KCool Tail Draggers LLC · Red Oak, IAN7139LAmoss Harold Lindsay III · Redmond, ORN7139PPendlay Heath V · Kalispell, MTN7139QFernander David · Enterprise, ALN7139TPhilpot John Michael · Liberty, MON7139UMott Charles A Jr · Chesapeake, VAN7139WWindover Wings LLC · Lancaster, PAN7139XBryk Steven L · Port Orange, FLN713AMApling Patrick H · Hudson, MIN713BDTate Ed N · Sheridan, ORN713BMMathieu Robert B · Delhi, LAN713CGDarrow John Kenneth · Soldotna, AKN713CHHopkins David Martin · Bell Buckle, TNN713CMLevy Jeremy · Apopka, FLN713CPCivil Air Patrol · Maxwell Afb, ALN713DBBourgoin Dale R Trustee · Saco, MEN713DERegistered aircraftN713EEHarper Larry · Marietta, GAN713EGRegistered aircraftN713FSTfs Air LLC · Loveland, CON713GAMustang Sally Aviation LLC · Camden, SCN713HRMontana Department Of Fish Wildlife And Parks · Helena, MTN713HVRutan Aircraft Flying Experience · Waller, TXFirst renewal noticeN713JADesert Sealants Corp · Queen Creek, AZN713JHMccauley James · Ithaca, NYN713JKSbarounis Carl A · Torrance, CAN713JLJula James M · Portland, ORN713JPArizona Technical Construction LLC · Lake Havasu City, AZN713JRO Reilly Robert · Houston, TXN713LSMendel Joseph · Naperville, ILN713LULiberty University School Of Aeronautics · Lynchburg, VAN713MMGannett Helicopters · Lander, WYN713MTSizemore John A · New Boston, NHN713NDUniversity Of North Dakota · Grand Forks, NDN713PMWestbank Fishing LLC · New Orleans, LAN713RBKay Timothy A · Kyle, TXN713REAks Aviation LLC · Arroyo Grande, CAN713SATextron Aviation Inc · Wichita, KSN713SJKoerner James L Trustee · Gilbert, AZN713SPCentral Airlines Inc · Leawood, KSN713SQTransportation Solutions & Logistics Inc · Orlando, FLN713SZN713sz LLC · Jacksonville, FLN713TBKasper Michael · Pahrump, NVN713USoco Aero Leasing LLC · Santa Rosa, CA
Back to AD 81-18-04 R2