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.
N8582ESkyborne Airline Academy Inc · Vero Beach, FLN8582JMarchione Laverne R · Diamondville, WYN8582MSkyborne Airline Academy Inc · Vero Beach, FLN8583Totorige Carson J · Glennallen, AKN8583BSkyborne Airline Academy Inc · Vero Beach, FLN8583NSkyborne Airline Academy Inc · Vero Beach, FLN8583VMorten John E DBA · Larimore, NDN8583YGray Michael W · Cheyenne, WYN8584DSkyborne Airline Academy Inc · Vero Beach, FLN8584TSkyborne Airline Academy Inc · Vero Beach, FLN8584WSawyer Clissie M · North Platte, NEN8585DMadsen Travis E · New Underwood, SDN8585HSkyborne Airline Academy Inc · Vero Beach, FLN8585YGospel Ministeries International Inc · Mc Donald, TNN8585ZSkyborne Airline Academy Inc · Vero Beach, FLN8586ASkyborne Airline Academy Inc · Vero Beach, FLN8586CGifford Thomas L · Canadian, TXN8586JSkyborne Airline Academy Inc · Vero Beach, FLN8586YTrue Glenn C Jr · Phoenix, AZN8587BDorsey Tony A · Anchorage, AKN8587DSouthard Bryan O · Moneta, VAN8587KSkyborne Airline Academy Inc · Vero Beach, FLN8587LSkyborne Airline Academy Inc · Vero Beach, FLN8587VCaprock Soaring Association · Littlefield, TXN8588BSavage James B · Gibsonia, PAN8588ELongaker Aviation LLC · Salem, VAN8588LSuper Pawnee LLC · Delafield, WIN8588PSkyborne Airline Academy Inc · Vero Beach, FLN8588WAndree Alfred L · Homer, AKN8589SSkyborne Airline Academy Inc · Vero Beach, FLN8589WCoke Roger T · Clarksville, INN858ASeppi Lance R · Hood, CAN858AUAb Prop Plane II LLC · Metairie, LAN858CHTriple Nickel Inc · Muleshoe, TXN858CPDae Aviation Enterprises Corp · Gilford, NHN858JBSale Reported · El Mirage, AZSale reportedN858KMAbsten Aviation LLC · Ashville, OHN858RLLeto Richard G · Parker, CON858RSTorrent Stephen C · Louisburg, NCN858SFlying Tigers Flight School Ltd · Houston, TXN858SBBusch James David · Tempe, AZN858SCNightscape Aerial Advertising LLC · San Diego, CAN858SMLoomer Donald W · Williston, NDN858TVwf Enterprises LLC · Coppell, TXN858VKChristiansen Aviation LLC · Wilmington, DEN858WKChristiansen Aviation LLC · Wilmington, DEN858XJChristiansen Aviation LLC · Wilmington, DEN858YTChristiansen Aviation LLC · Wilmington, DEN858ZStearman Air Tours Inc · Gatesville, NCN858ZKChristiansen Aviation LLC · Wilmington, DE
Back to AD 81-18-04 R2