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.
N76990Brown Hector M · Glenwood Springs, CON7699GZhao He · Yaphank, NYN7699JHamilton John B · Stafford, VAN769AMeridian Aircraft LLC · Wilmington, DEN769AKThomas Cole A · Fairbanks, AKN769ATTarragon Aircraft USA LLC · Pekin, ILN769CERogers Charles M · Pilot Hill, CAN769GALong Island Aviators LLC · Seaford, NYN769GMN373hp LLC · Ladera Ranch, CAN769JBGibson Randy L · Clinton, TNN769NDN769nd LLC · Sidney, MTN769NERegistration Pending · Pottstown, PARegistration pendingN769RAMcclure Dennis N · Mcalpin, FLN769RVWinston James R · Cornelius, NCN76ADWerner Richard · Syosset, NYN76ATCarney Raymond L · Newton, ALN76AUHayes Michael Mckool · Destin, FLN76BCYackley Ranches · Onida, SDN76BDAndersen Diane M · Palm City, FLN76BKMohler Tucker A · Sautee Nacoochee, GAN76CMRegistration Pending · New Braunfels, TXRegistration pendingN76CRTownsend Joseph A · Buckeye, AZN76DHKarapelou James M · Allentown, PAN76DMHendrix Aviation Inc · Plantation, FLN76DRAppleget Edward L · Glendale, AZN76DSDeemer Jerry C · Granbury, TXN76DUL&P Of Mke LLC · Milwaukee, WIN76EVKuhn Bernard O · Ripon, CAN76FCBlackhawk Holding Corp · Wilmington, DEN76FKSmith Fleet K IV · Stephens City, VAN76FPSoest Ernest D · Quartz Hill, CAN76GCEdgerton Richard T · Arlington, WAN76GDCoulter Dennis W · Lincoln, CAN76GLSullivan Vincent E · Centerville, IAN76GZLankford Philip S · San Marcos, CAN76HBSinger Michael · Mission Viejo, CAN76HJAmalong Timothy M · Tucson, AZN76HKDodson International Parks Inc · Rantoul, KSN76HSDelgrosso Dennis W · Saranac, NYN76HYCarley Dale H · Griffin, GAN76JAJahawk Leasing LLC · Sugar Grove, ILN76JEReedy Dana J · Columbus, INN76JGSublett Farms · Ardmore, ALN76JKKrajewski Jason · Portland, ORN76JMWalton Daniel · Schaumburg, ILN76JRWeiner Lupita A · Mineola, TXN76JVLeonardo David · Hollister, CAN76JYYoder Jeremy L · Sarasota, FLN76KCCulhane Mark E · South Windsor, CTN76KDSchneider Aaron J · Chugiak, AK
Back to AD 90-04-06 R1