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.
N76KFRegistration Pending · Grenada, MSRegistration pendingN76KRSorensen Bjarne K · Vero Beach, FLN76KSSchroepfer Ken J · Pecatonica, ILN76LThacker Flying Club LLC · Griffin, GAN76LCHacienda Hills Skyhawk LLC · Laveen, AZN76LMPavlovich Martin · Menomonee Falls, WIN76LNHillsboro Aero Academy LLC · Hillsboro, ORN76LYYonge Laurie W Jr · Oklawaha, FLN76MKMelbourne Flight Training LLC · Melbourne, FLN76MLDunn Courtland E Jr · West Grove, PAN76MMRichardson John H · Monticello, NMN76MXAzdair Jamie A · Alhambra, CAN76NATri Flying Tigers Inc · Wilmington, DEN76NCDonald K Ashley · Bradenton, FLN76NKNaples Jet Management LLC · Naples, FLN76NNSale Reported · Middletown, OHSale reported, canceledN76NPCollins Shannan S · Justin, TXN76PFRodriguez Amable Omar · Hialeah, FLN76PPGround Effect Aviation LLC · Ogden, UTN76PQBoyd Benjamin L · Kila, MTN76PTMcmurtrey Michael · Farmington, MNN76RSCocke James A · Clarendon, TXN76RTEmax LLC · Perry, GAN76RVVandevort Lynn A · Manitowoc, WIN76RWThomas Allen C · Willow, AKN76SBAdams Simmie A · Bealeton, VAN76SHConrad Edgar · Mc Alpin, FLN76SLLarsh Steven S · Libby, MTN76SSNorth Texas Aeronautics LLC · Burleson, TXN76TAAhlhorn Travis W · New Braunfels, TXN76TCCox Thomas R · Kirkland, WAN76TJBais Tim · Escondido, CAN76TXBrenner Kurt · Saint Ann, MON76VAHartzell Propeller Emp Flg Club · Piqua, OHN76VMSwartz Aviation Group LLC · Argyle, TXN76WEEnglert William R · Advance, NCN76WLBuckel Joseph T · Ellison Bay, WIN76WNCorben David Meyer · Lafayette, INN76WPHowes Robert P · Belleview, FLFirst renewal noticeN76WWOakley James H · Spring Valley, CAN76WYFarmer Bill · Argyle, TXN76XGreen Steven L · Fairbanks, AKN76YHose Jerry A II · Oregon, ILN76YBJames Marvin L · Scio, ORN76YDBeasley Charles A · Spencer, VAN7700MWood Duck Loop LLC · Mooresville, NCN7700WGleasman Steven J · Rockton, ILN7701AEdb Air Inc · Wilsonville, ORN7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeN7701HRenshaw Raymond E · Huntersville, NC
Back to AD 90-04-06 R1