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.
N7232WAwmr LLC · Conroe, TXN7233JPinnick Andrew · Beckley, WVN7233KWalsh Steve · Anchorage, AKN7233YPacific North Air LLC · Portland, ORN7234FBrinker Joe E · Little Hocking, OHN7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeN7234PEagle Ag Services LLC · Lees Summit, MON7234QLavinio Stephen E · Southampton, NYN7234VMorten Jesse L · Larimore, NDN7234WMoco Aviation LLC · Moultonborough, NHN7235Hale Edward S Jr · Brawley, CAN7235AValiair Limited Co Trustee · Casper, WYN7235GMcnair William H · Gold Beach, ORN7235WMorris George · Redlands, CAN7236DGo North Productions LLC · Glennallen, AKN7236FRegistered aircraftN7236JBackman Randy L · Bellingham, WAN7236KSchwend Brian · Forsyth, MTN7236MWright Steven William · Bend, ORFirst renewal noticeN7236PMark A Smith Aircraft Sales Inc · Homosassa, FLN7236QTeren Nelson F · Friday Harbor, WAN7237DBobinchak Richard G · Sheridan, WYN7237GIvoprop Corp · Long Beach, CAN7237QMartin Bach Aviation LLC · Cornelius, NCN7237WPetropulos James J · Juneau, AKN72383Niagarawings Aviation LLC · Niagara Falls, NYN7238FDoll William J · Carlisle, PAN7238KGarber Bruce E Trustee · Sheridan, WYN7238LHorizon Flight Center LLC · Chesapeake, VAN7238VKnutson Wayne R · Thompson, NDN7238WRupert Shon D · Greenwood, ARN7239DHaning Thomas B · Vian, OKN7239KHodgson Joel R · Palmer, AKN7239PMccabe Gregory · Melbourne Beach, FLN7239WWiza Jason · Custer, WIN723AGShortt Aircraft Leasing LLC · Wilmington, DEN723AJCavorite Aviation LLC · West Jordan, UTN723AKFrohnapfel Mark T · Cordova, AKN723CCavner Hudson A · Port Alsworth, AKN723CBPrivateflyer LLC · Lewes, DEN723CFCay Air Inc · Largo, FLN723CJNicholson Scott V · Kalamazoo, MIN723CLVan Why Johnathan Ryan · Corvallis, ORN723CMOmbra Aria LLC · Dover, DEN723CTN723ct LLC · Bend, ORN723GPuerta Jose Fernando Del Valle · Miami, FLN723GALong Island Aviators LLC · Seaford, NYN723JSAlbertson James M · Westville, FLN723KCCornelius Robert · Vinemont, ALN723LHParker Robert · Oklahoma City, OK
Back to AD 81-18-04 R2