AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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.
N6363UTf Skies LLC · Mount Pleasant, TXN6363WKvidera N6363w LLC · Webster, WIN6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHN6364JVenture West LLC · Mesa, AZN6364PAdamczyk Douglas · Surprise, AZN6364RWilliams Jacqueline · Mint Hill, NCN63659Droege Robert Michael · Saratoga Springs, NYN6365CWingsleasing LLC · Wichita, KSN6365FRindo David J · Lowell, MAN6365JLeverton James F · Cannon Falls, MNN6365NSouth Dakota State University · Brookings, SDN6365RPrentice Timothy W · Kingman, AZN6365WGaglianello Mark · Magnolia, NJN63663Lake Aviation LLC · Murfreesboro, TNN6366CHalpin Aviation Inc · Eden Prairie, MNN6366FDerose Joseph F · Salt Springs, FLN6366JTaff Jehu Thomas · Greenville, NCN6366LFritel Construction Co Inc · Stanley, NDN6366MWaymire Thorne L · Big Bear Lake, CAN6366NCarlson Eric S · Kodiak, AKN6366PN6298p Inc · Okeechobee, FLN6366QLibre Air LLC · Norfolk, VAN6366RBatta Krishnakanth · Mountain House, CAN6366TBaclich Brett J · Dubuque, IAN6367CWings High Aviation LLC · Fayetteville, NCN6367LM&S Aero LLC · Wilmington, DEN6367PFrancis Thomas R · Lamar, CON63681American Patrols Inc · Midland, TXN6368JPrins Damon · Angels Camp, CAN6368NS&S Aviation LLC · Morse, LAN6368PRbr Aircraft Inc · Albuquerque, NMN6368WMarine Investments Llp · Morganton, NCN63693Budd Aircraft Enterprises Inc · Chesterfield, MON63694Upper Valley Aero LLC · Hanover, NHN6369JBreslawski Nicholas · Hamlin, NYN6369NEberhart Royce R · Covington, GAN6369PKeith Don Paul · Bakersfield, CAN6369TRegistered aircraftN6369USpecialty Aero Services LLC · Bayside, WIN6369WStrouth Adam G · Raleigh, NCN636BS636bs Corp · Media, PAN636CPCivil Air Patrol · Maxwell Afb, ALN636CXNewton Property Leasing LLC · Greene, IAN636DWButler Blake B · Shelbyville, TNN636FTFlorida Institute Of Technology · Melbourne, FLN636GTSky Blue Aero LLC · Huntersville, NCN636JCJohnson Training Institute LLC · Zachary, LAN636NDUniversity Of North Dakota · Grand Forks, NDN636PGlenn R Johnson Trustee · Calmar, IAN636RJAirspeed Aviation Associates LLC · Austin, TX
Back to AD 87-10-06 R1