AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N7429YDewitt Troy C · Lake Elmo, MNN742BBMike Sierra Bravo LLC · Port Orange, FLN742CGValley Sprayers Inc · Park River, NDN742CSSnider William A · Hye, TXN742GGingell Lance · Cottonwood, CAN742GGBelsaas Richard · Rapid City, SDN742MADinning Gregory J · Shirley, MAN742PASkywest Leasing Inc · St George, UTN742RVWehrell Kenneth Kaeye · Marietta, GAN742TAZach David E · Wayne, NEN742TJInternational Air Services Inc Trustee · Carson City, NVN742WGTop View Corp · Livingston, MTN74302Airpower Enterprises Ltd · Tampa, FLN7430RGomez Rodolfo · Sierra Vista, AZN7430VViaspot Inc · Sheridan, WYN7430WI Was Inverted LLC · Fort Myers, FLN7430YLavion LLC DBA · Zeeland, MIN74319Koch 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, CAN7432RHeil 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, WYN7434Armstrong Charles R · Annapolis, MDN74343Hindes Philip DBA · Charlotte, TXN74347Spitzer Helicopter LLC · Woodland Hills, CAN74349Prieve Barton G · Aurora, CON7434RMyers Lisa · Sandpoint, IDN7434WCarolina Clouds LLC · Dover, DEN74350Truong Philippe M · Fayetteville, ARN74356Windsor Robert M · Norman, OKN74359Ohlsson Patricia · Port Orange, FLN7435KHickey Aero Services LLC · White Hills, AZN7435VFreebird Ventures Inc · Oak Lawn, ILN7435WStanley Thomas Russell · Brighton, CON7435YStc Aviation LLC · Wilmington, DEN7436GChickadee Aviation LLC · Rangeley, MEN7437Fedorka Paul R Trustee · Soldotna, AK
Back to AD 90-04-06 R1