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.
N9353VLangholz Denise M · Covington, WAN93541Gibbs Frederick L · Flagstaff, AZN9354JLamb David S · Yuba City, CAN9354MFresh Air Properties LLC · Hayesville, NCN9354SLinda Ann Trust LLC · Dover, DEN9354VPinckney Robert L · Elgin, SCN9354WBlue Horizon Aircraft LLC · Wilmington, DEN93554Pittman Randy L · Morris, ILN9355DHarris Chet A · Anchorage, AKN9355SBestway Pilot Car LLC DBA · Metropolis, ILN9355WEngland Noah C III · Lowell, NCN9356DHammond Dwight L · Burns, ORN9356HQuad Cities Aero LLC · Bettendorf, IAN9356JVali Air Service LLC · Livingston, MTN9356MRegistered aircraftN9356PMente Charles · Homestead, FLN9356RQuality By Design Inc · Leesburg, FLN9356SHeman Christopher M · Lees Summit, MON9356VWilson Willard L · Daphne, ALN9356WOrtman Stephen B · Mill Creek, WAN93570Huffaker Kenneth Scott · Post, TXN9357DLeary Patrick W DBA · Lewistown, MTN9357JKirchoff Jennifer L · Hamden, CTN9357MSpencer Jared · Mandeville, LAN9357PNewman Joseph G · Grand Ledge, MIN9357SWeiser Denis P · Osceola, IAN9357VWise Christopher J · Plano, TXN9358CMiloud Chadd K · Fort Worth, TXN9358ELechmanski Philip J · Shelter Island, NYN9358LUnited States Air Force · Eglin Afb, FLN9358PJeneson Tim · Ketchum, IDN9358SAnderson Justin T · Franklin, OHN9358VEickman Jaret · Scottsdale, AZN9358WPena Evan M · San Antonio, TXN9359DFejes James Michael Jr · Anchorage, AKN9359HWarren Flying Club · Troy, MIN9359MStrohacker Louis W · Kerrville, TXN9359NMorristown Flying Service Inc · Talbott, TNN9359PCarter James D · Carlton, TXN935AZN935az LLC · Miami, FLN935CWIn Flight Aircraft LLC · Howell, MIN935DELong Island Aviators LLC · Seaford, NYN935ERChristiansen Aviation LLC · Wilmington, DEN935GArcher Flight LLC · Wilmington, DEN935KMBeachy Philip R · Bonners Ferry, IDN935LTAerosim Flight Academy · Sanford, FLN935MBBrewer Marcus · Churubusco, INN935PTTailspin Tommys Inc · Port Townsend, WAN935SHZoom Zoom LLC · Scottsdale, AZN93600Babcock Barry B · Monument, CO
Back to AD 87-10-06 R1