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.
N7153PKnutson Daniel T · Lodi, WIN7153USmith Coty C · The Colony, TXN7153VTamadon Farhad F · Chino Hills, CAN7153WClearview Flying Club Inc · Westminster, MDN7153ZCarson Cubs LLC · Yelm, WAN7154GJuranich William M · Kent, WAN7154KSwanson Gc · Valentine, NEN7154WBeller Construction & General Contracting LLC · Lewiston, IDN7154ZCopper River Airmotive LLC · Copper Center, AKN7155DTetzlaff Christian D · Athens, GAN7155KSheffels L And Son · Wilbur, WAN7155LWright David M · Winchester, CAN7155NQualitair LLC Trustee · MichelstadtN7155QValley Ltd Of Fayetteville · Fayetteville, NCN7155RVander Ploeg Robert · Sebring, FLN7155UProtze Mark · Anacortes, WAN7155WHillsboro Aero Academy LLC · Hillsboro, ORN7155YSheasley George · Eagle Creek, ORFirst renewal noticeN71563Treml Edward I · Kewaunee, WIN7156BJstream Lc · Sheridan, WYN7156DWilliams Eron T · Overbrook, KSN7156KAttwood Nona M · Fairbanks, AKN7156LExcalibur Aviation LLC · Amelia Court House, VAN7156PWeinzapfel Joe M · Muenster, TXN7156QAmerican Patrols Inc · Midland, TXN7156RBlair Marianne T · Waynesboro, VAN7156ZClum David V · Anchorage, AKN7157BOwyhee Aviation LLC · Provo, UTN7157DNewgent Isaac T · Westminster, MDN7157GAero Quest LLC · Olive Branch, MSN7157LZuwerink Michael J · Holton, MIN7157USl Motorsports Inc · Paradise Valley, AZN7157YTailwind Consulting LLC · Port Orange, FLN7157ZUrstadt Christopher M · Girdwood, AKN7158CAeronauts Flying Club Inc · Newton, MAN7158DTotal Flight Aircraft Leasing LLC · Apex, NCN7158GHawk Aviation Inc · Rush City, MNN7158KDoody James P · South Glens Falls, NYN7158LSears Wes L · Tacoma, WAN7158PJinnette James · Raleigh, NCN7158RVenango Regional Aero Group Inc · Franklin, PAN7158SHawaii Pacific Aviation Inc · Kailua Kona, HIN7158UMenjivar Christian J · Missoula, MTN7159GN7159g LLC · Jacksonville, ARN7159LRowlett Roger S · Hamilton, NYN7159PAdams George D · Franklin, INFirst renewal noticeN7159UChamberlain Gary M · Challis, IDN7159WBami LLC · Clymer, PAN7159YPepmiller Scott C · Panama City Beach, FLN715AGGreen Allen R · Westminster, CO
Back to AD 81-18-04 R2