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.
N742BBMike Sierra Bravo LLC · Port Orange, FLN742CGValley Sprayers Inc · Park River, NDN742CSSnider William A · Hye, TXN742GGingell Lance · Cottonwood, CAN742HMBennett Aviation LLC · New York, NYN742MADinning Gregory J · Shirley, MAN742PASkywest Leasing Inc · St George, UTN742RHUnited Helicopter Leasing LLC · Honolulu, HIN742RVWehrell Kenneth Kaeye · Marietta, GAN742TAZach David E · Wayne, NEN742TJInternational Air Services Inc Trustee · Carson City, NVN74302Airpower Enterprises Ltd · Tampa, FLN7430PSchlosser Nelson L · Tucson, AZN7430RGomez Rodolfo · Sierra Vista, AZN7430VViaspot Inc · Sheridan, WYN7430WI Was Inverted LLC · Fort Myers, FLN7430YLavion LLC DBA · Zeeland, MIN7430ZMayes Brett R · Williams, CAN74319Koch Christopher G · Coloma, MIN7431DWilcox Darrol A · Nenana, AKN7431JHemmings Jack · North Vernon, INN7431VErnst Albert S III · Buda, TXN7431WKonkoi Roger E · Lumberton, NCN7431YRegistration Pending · Lynchburg, VARegistration pendingN74323Clark Daniel M · San Pedro, CAN7432DBlack Delwyn Joe · Irving, TXN7432GNichols Roy D · Cadillac, MIN7432JSingcharoen Kitikorn T · Riverside, CAN7432LStandard Air LLC · West Linn, ORN7432RHeil Dan M · Hooker, OKN7432VSpires William B · Minden, NVN7432WSheppardfox LLC · Germantown, TNN7433DPierce Stephan L · Graham, TXN7433GStyles Brian P · Cullman, ALN7433JYawn Charles L Jr · Denham Springs, LAN7433KMills Randall J · Monroe, MIN7433RValiair Lc Trustee · Casper, WYN7433ZDas Air Inc · Wilmington, DEN7434Armstrong Charles R · Annapolis, MDN74343Hindes Philip DBA · Charlotte, TXN74347Spitzer Helicopter LLC · Woodland Hills, CAN74349Prieve Barton G · Aurora, CON7434LIsland Wings Inc · Fort Lauderdale, FLN7434RMyers Lisa · Sandpoint, IDN7434WCarolina Clouds LLC · Dover, DEN74350Truong Philippe M · Fayetteville, ARN74353Hofer Gary D Trustee · Huran, SDN74356Windsor Robert M · Norman, OKN74359Ohlsson Patricia · Port Orange, FLN7435VFreebird Ventures Inc · Oak Lawn, IL
Back to AD 87-10-06 R1