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.
N66JFNaylor Matthew · Canyon Lake, TXN66JHHefner James L · Oro Valley, AZN66JJWilliams Nicholas Indrais · Pickerington, OHN66JSSisson Jp · Litchfield, ILN66JWNowell Borders Equipment G P Inc · Edinburg, TXN66KBNorris Victor H · Bremerton, WAN66KPRegistration Pending · Batesville, TXRegistration pendingN66KYKelcher Randi R · Saint Charles, MON66LKeating Gregory D · Carpenter, SDN66LBHermeling Mark A · Vail, AZN66LGHarpenden Corp · Los Angeles, CAN66MACp Aviation · Santa Paula, CAN66MGPeeler Dixie L · Sandy, UTFirst renewal noticeN66MMTake Flyt LLC · Eagle Lake, MNN66MNGoebel Michael M · Conroe, TXN66MWWhidden Marion H · Okeechobee, FLN66NDMiller Aircraft Services Inc · Crookston, MNN66PArchangel One LLC · Lewes, DEN66PMMajestic Air LLC · Lowell, MIN66PRPeterjohn Management II LLC · Pound Ridge, NYN66PTRobin194 LLC · Prescott Valley, AZN66RDTiger Air 2 LLC · Atlanta, GAFirst renewal noticeN66RPHedges Aviation Inc · Ronkonkoma, NYN66SEDaubenberger Joseph R · Hood River, ORN66TBTurner Brothers LLC · Middleboro, MAN66TKCollins Raymond S · Loomis, CAN66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CAN66TSTall Timber Flying Service LLC · Kalispell, MTN66TVDodson International Parts Inc · Rantoul, KSN66VKCummings Michael F Jr · Wellsboro, PAN66WEBurns Gregory A · Newnan, GAN66WHSix Six Whiskey Hotel LLC · Mount Vernon, KYN66WMTriple R & B Aviation LLC · Miami Beach, FLN66WNMeyer Robert J · Canyon, TXN66XCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66XEFisher Michael A · Logan, UTN66YEaa Aviation Foundation Inc · Oshkosh, WIN66YCWatts Loren · Hermiston, ORN67000Registration Pending · Johns Island, SCRegistration pendingN6700CKelly Aviation & Investigation LLC · Vail, AZN6700FRunels Thomas L · Battle Creek, MIN6700HNashua Flyers Inc · Nashua, NHN67010Robinson Helicopter Company Inc · Torrance, CAN67013Del Ag Aero LLC · Milton, DEN6701JJones Bob J Trustee · Littleton, CON6701NFreeman Alan M · San Antonio, TXN6701PHammond Craig D · Lawton, OKN6701RAirplane And Drone Flight Instruction LLC · Orlando, FLN6701TAtlanta Aviation Academy Inc · Lawrenceville, GAN6701VHub City Aviation Academy LLC · Lubbock, TX
Back to AD 87-10-06 R1