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.
N7719XBas Part Sales LLC · Greeley, CON771AAJones Aircraft Co LLC · Cross Plains, TNN771ACMorrison William Fraser · Bonners Ferry, IDN771BDMcginty Edwin R · Eagle, IDN771BZOne Bz LLC · Clarklake, MIN771CAChristiansen Aviation LLC · Wilmington, DEN771CBSkycruise Inc · Largo, FLN771JNSteiner Martin A · Bellaire, OHN771JSRhcp Inc · Virginia Beach, VAN771KMCouples Therapy LLC · Hampton, NHN771LBLat Of Florida LLC · Winter Park, FLN771LMBruntjen Eric · Decatur, ILN771LPRudisaile Joseph · Arlington, TXN771MALucky Dog Air LLC · Edmond, OKN771MBMathis Alan L · Moultrie, GAN771MKHemberger Andrew J · Troy, ILN771MMTaildragger LLC · Lakeside, ORN771MRSmith Nathan · Palmer, AKN771NDUniversity Of North Dakota · Grand Forks, NDN771PCBuzzair Inc · Wilmington, DEN771PTPilot Training Center LLC · Miami, FLN771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLN771RCReynolds Ronald · Ammon, IDN771SHHillsboro Aero Academy LLC · Hillsboro, ORN771VYGarcia Pedro · Hudson, OHN771WKalmar Istvan · Keller, TXN771WSCampbell Reginald G · Hilo, HIN7720DBarnhill Jerry D · Longville, LAN7720GZulu Jets LLC · Boerne, TXN7720J3c Aviation Lc · Clare, MIN7720WLagrange LLC · East Helena, MTN7720YEastern Kentucky University · Richmond, KYN7720ZAnderson Joel M · Starkweather, NDN7721BHill Jack D · Tulsa, OKN7721DRenick Tyler C · Wichita Falls, TXN7721GWurtsboro Airpark LLC · Wurtsboro, NYN7721JJgm Aviation LLC · Spring, TXN7721NRome Nicholas S · Olathe, KSN7721WKosobud Timothy J · Adams, WIN77222Davis Sam Alan · Wendell, NCN7722GKnaack Roland · Cumming, GAN7722HRickman Allen K · Absarokee, MTN7722ZCentral California Soaring Association Inc · Avenal, CAN7723DLutz Roald F · Sandia Park, NMN7723JHabig Robert D · Sheridan, INN7723NFord Charles D · Clifton, TNFirst renewal noticeN7724GWind Walker LLC · Tucson, AZN7724PWay Steven J · Colleyville, TXN7725NHangar Twenty Two Aviation LLC · Athens, TXN7725PTully Martin · Idalou, TX
Back to AD 87-10-06 R1