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.
N7204GGibson James E · Tenino, WAN7204PPittner Hans C · Goshen, NYN7204QTexas Air Rangers LLC · Mckinney, TXN7204WKlein Kaylin · Stillwater, OKN7204ZKettley Rick W · Steward, ILN7205GJones Keith · Tucson, AZN7205PL F Rothschild & Company Inc · Shingle Springs, CANon-citizen corporation, flight hours not reportedN7205QN7205q LLC · Titusville, FLN7206CDwyer Benjamin J · Colorado Springs, CON7206FVoyage Capital Ventures LLC · Knightdale, NCN7206LWilliams Harry D III · Summerland Key, FLN7206QN7206q LLC · Myrtle Beach, SCN7206WSchimmel O L · Port Hueneme, CAN7206YSkyflite LLC · Hillsboro, ORN7207Board Of Trustees · Battle Creek, MIN7207BThomas Conners · Melbourne Beach, FLN7207DHerrick David L · Mont Vernon, NHN7207FLandmark Title Inc · Clovis, NMN7207GCowden Flying Services Inc · Fort Worth, TXN7207JErhardt Industries LLC · Ottumwa, IAN7207PSteinbach Philipp · Bentonville, ARN7207QMountain Peaks Aviation LLC · Clancy, MTN7207WValkaria Flyers LLC · Palm Bay, FLN7208DCopper River Airmotive LLC · Copper Center, AKN7208FWignot Andrew R · Oceanside, CAN7208GBurgess Keith · Arnoldsville, GAN7208JWelby Samantha · Eastampton, NJN7208WSky View Aviation LLC · Porter, OKN7209DBlue Weayne E · Rochester, NYN7209FNew Garden Township · Landenberg, PAN7209GElite Planes LLC · Menifee, CAN7209QKimble Leon · Rocky Hill, CTN7209YThy Will Be Done Here LLC · Reno, NVN720ACKcsi Aerial Patrol Inc · Bakersfield, CAN720BHPetersen Bennett C · Medina, OHN720CBLee Douglas A · Quincy, CAN720FLExecutive Flight Training & Services LLC · Sanford, NCN720GCCox Gary E · Davis, CAN720GPCharlie Hotel Corp · Wilmington, DEN720JBSchoettle Steve P · Heber Springs, ARN720JHTuysserkani Bijan · Boulder, CON720JPThomas Ryan J · Bend, ORN720KMTrubee Jay G Trustee · Palm Desert, CAN720LSBellotte Travis J · Morgantown, WVN720MGRegistered aircraftN720NWNunez Frank · Orlando, FLN720PAValiair Lc Trustee · Casper, WYN720RKLong Philip Charles · Ojai, CAN720SHBrooke James B · Salisbury, MDN720SPFlying L Aircraft Inc · Fort Denaud, FL
Back to AD 87-10-06 R1