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.
N76WPHowes Robert P · Belleview, FLFirst renewal noticeN76WWOakley James H · Spring Valley, CAN76WYFarmer Bill · Argyle, TXN76XGreen Steven L · Fairbanks, AKN76YHose Jerry A II · Oregon, ILN76YBJames Marvin L · Scio, ORN76YDBeasley Charles A · Spencer, VAN7700ATim Whitfield Aviation Inc · Fairfield, NCN7700JLuke Motley IV · Sherman, TXN7700MWood Duck Loop LLC · Mooresville, NCN7700PBarber Chris · Toney, ALN7700WGleasman Steven J · Rockton, ILN7701AEdb Air Inc · Wilsonville, ORN7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeN7701HRenshaw Raymond E · Huntersville, NCN7701MHurt Roy DBA · Newark, OHN7701NN5746u LLC · Dover, DEN7702BSkyborne Airline Academy Inc · Vero Beach, FLN7702DAnderson Leonard M · Lakeside, MTN7702HPaphos Airways LLC · Farmingdale, NYN7702LPrp Enterprises LLC · Lake Forest, CAN7702MCullen William Edward · Mill Valley, CAN7702NN7702n LLC · Glenford, OHN7702VBrown Warren C · Pasadena, CAN7702WMud Duck LLC · Dover, DEN7703CEdb Air Inc · Wilsonville, ORN7703HWatt Ernie T · Scooba, MSN7703YNixon Christopher M · Washington, INN7703ZBarrett Jane T · Tehachapi, CAN7704DSkyborne Airlines Academy Inc · Vero Beach, FLN7704JTatum John T · Danville, ARN7704MCollins Benjamin N · Chapel Hill, NCN7704PDolin Irving M · Gardner, KSN7704SHolte Bruce C · Thief River Falls, MNN7704WKelly John T III · Denison, TXN7704ZAerial Banners Inc · Pembroke Pines, FLN7705Ck Aviation LLC · Castle Pines, CON7705DPumphrey Ronald W · Houston, MSFirst renewal noticeN7705GKimbrel Mark D · Rochester, WAN7705HNordic Flyers Inc · Plymouth, MNN7705NNagy Peter · Sebring, FLN7706HSgarrella William G Jr · Lovettsville, VAN7706NSealey John W · Athens, TXN7706YHighway Whisperer LLC · Wilmington, DEN77077Hammarback Inc · East Grand Forks, MNN7707GAtd Pilot Training LLC · Kansas City, MON7707JBowersox James · Lititz, PAN7707NAviation Trust Co LLC Trustee · Oklahoma City, OKN7707PSweitzer Cameron D · Warrensburg, MON7707WCockrell Amos L · Florence, AL
Back to AD 81-18-04 R2