AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N8583NSkyborne 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, FLN8585DMadsen 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, VAN8588PSkyborne Airline Academy Inc · Vero Beach, FLN8589SSkyborne Airline Academy Inc · Vero Beach, FLN858ASeppi Lance R · Hood, CAN858CPDae 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, TXN859Registered aircraftN8590VNichols Dean Emerson · Clearwater, FLN8590YNorthern Aviation LLC · Palmer, AKN8590ZSkyborne Airline Academy Inc · Vero Beach, FLN8591CSkyborne Airline Academy Inc · Vero Beach, FLN8591DConservative Three LLC · Taft, CAN8592DRussell Terrell G · Isola, MSN8592ERegistration Pending · Vero Beach, FLRegistration pendingN8592NSluder George L · Willard, NCN8592VWest Michigan Aviation Academy · Grand Rapids, MIN8593CPockrus Pat B · Mineral Wells, TXN8593DTravis Charles E · Fairbanks, AKN8593FTriple F Flying Inc · Benton, PAN8593GPiper Aircraft Inc · Vero Beach, FLN8593VShoemaker John L · Arnold, MDN8593YNickajack North LLC · Ocala, FLN8594Campbell Jaret R · Watertown, SD
Back to AD 90-04-06 R1