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.
N803CDFlying Monkey Aviation LLC · Wilmington, DEN803DCSleeper William H · Bainbridge Island, WAN803DRRegistration Pending · Bayou Vista, TXRegistration pendingN803EHContinental Helicopters Inc · Sheffield, TXN803ERBenson Catrina D · Palmdale, CAN803FMPreciado Eusebio Barreda · Canyon Country, CAN803HPP & W Investments Inc · Wilmington, DEN803KSKansas State University · Salina, KSN803RToci Gabe C G · Anchorage, AKN803RMAs Filed LLC · Culver City, CAN803RTShuler Air Corps LLC · Wilmington, DEN803SBEatinger Alvin R · Ashland, ORN803SPDodson International Parts Inc · Rantoul, KSN803TWGsfcpp Corp · Palm City, FLN8040Collins Leon Marshall · Ozark, ALN80407N80407 LLC · Rehoboth Beach, DEN8040DReboot Charity Inc · West Palm Beach, FLN8040PSutton Thomas C · Corning, NYN8040WJeff Abrams-2 LLC · Ocala, FLN8040ZZilinsky Robert F · Willowbrook, ILN80414Garn Darrell L · Palmetto, GAN80419Korona Lawrence K · West Paterson, NJN8041BIchtou LLC · Dover, DEN8041PEnsign James P · N Richlnd Hls, TXN8041WBas Part Sales LLC · Greeley, CON80421Kuder Kyp E · Rogers, NDN80424Johnston Robert K · Sylvania, GAN80425Fellows Roy H · Augusta, KSN80426Pcb Aviation LLC · Davidson, NCN8042BSummerskyz Inc · Saint Joseph, ILN8042DYounger Tyler J · Bakersfield, CAN8042FFlying Hawks Inc · Palmyra, WIN80434King William Daniel · Southlake, TXN80436N80436 LLC · Columbia, MSN80439Oklahoma State University · Stillwater, OKN8043GConnor Robert L · North Little Rock, ARN8043JHartland Helicopters LLC · Edinburg, TXN8043RPat Brown Aviation LLC · Dodge Center, MNN8043UClassic Banjo LLC · Richmond, KYN8043WMcabee Aviation LLC · Fresno, CAN8043YN56453 LLC · Bowie, MDN80440Rockey John · Jupiter, FLN80441Archer Aircraft LLC · Wilmington, DEN80442Washburne Seth P · Dallas, TXN8044DGillen Sean P · Arlington, TXN8044GTml Services LLC · The Villages, FLN8044LOverton Larry D · Hermiston, ORN8044NN7396w LLC · Coeymans Hollow, NYN8044RCobb Gerald E · Jacksonville, FLN8044TArcher Aircraft LLC · Wilmington, DE
Back to AD 81-18-04 R2