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.
N78RTMorris Coady C · Russell, KSFirst renewal noticeN78SEFlight Fundamentals Inc · Willcox, AZN78SKCleveland Gary J · Plymouth, INN78SWSidewinder Aircraft LLC · Yulee, FLN78TACti Aircraft Leasing LLC · Memphis, TNN78TGGardner Terrence L · Grassy Creek, NCN78TKFinseth Lowell J · Fountain, MNN78TMBowlin Ronald R · Camarillo, CAN78TSCeleritas Corp · Cranford, NJFirst renewal noticeN78TXDragger Aviation LLC · Wildwood, MON78USUtah State University · Logan, UTN78VLAdams Michael · Oxnard, CAN78VMPileggi Anthony · Leland, NCN78WARtd Aviation LLC · Hillsborough, NJN78WBDuffy James R · Boise, IDN78WESouth Delta Aviation Inc · West Helena, ARN78WGBarros Da Costa Cristiano Manuel · Grand Forks, NDN78WSHjelmstad David J · Burnsville, MNN78WTCole Thomas Ed · White Settlement, TXN78WYKelly Erin Christopher · Bend, ORN78YDoster Michael L · Nampa, IDN79000Kemmis Sidney C · Prophetstown, ILN79001Pau Hana Enterprises LLC Series IV · Boulder City, NVN79002Fremont Aviation Inc · Fremont, NEN79004Palmer Joe A · Meridian, IDN79009Birkholz Raymond J · Boulder, CON7900CSdd Aviation LLC · Thomasville, GAN7900GGreat Plains Enterprises LLC · Wilmington, OHN7900HMartin Robert C · Farmington, MEN7900PGoco Wireless Inc · Goliad, TXN7900WDiedrich Paul E · Fort Mill, SCN7900YLone Star Aircraft Holding Group LLC · Plano, TXN79012Brewer Jeremiah L · Eagle River, AKN79013Woods Michael F · Hamilton, NJN79014Fcs Aviation LLC · Lewisport, KYN79015Flying Weaners Inc · Jacksonville, FLN7901CFrost Aviation Alliance LLC · North Hollywood, CAN7901GRaines Adam D · Ridgewood, NJN7901YHinshaw Eric C · Lake Wales, FLN79021Smith Timothy C Trustee · Riverton, WYN79024Jwp Flying Services LLC · Chatfield, MNN79027Arrow North LLC · Missoula, MTN79028Jdc Aviation LLC · Upland, CAN7902SN7902s Wings LLC · Forest City, PAN7902WHicks Mark T · Newark, CAN7902YCohn David · Port Townsend, WAN79031Smith Robert L II · Spencer, WVN79036Buiqui Aerospace Corp · Kissimmee, FLN7903CHocking Valley Flying Club Inc · Hebron, OHN7903GDunn Patrick J · Denver, CO
Back to AD 81-18-04 R2