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.
N5241PAtwater John G · Vero Beach, FLN5241QWings Over Texas Holdings LLC · Denton, TXN52426Smtm Holdings Inc · Wilmington, DEN5242DR&R Aero Services LLC · Eden Prairie, MNN5242HJohnson Steven D · Oklahoma City, OKFirst renewal noticeN5242LSimpson Jacob William · Crescent Springs, KYN5242RProctor Daniel L · Elkton, VAN5242XMilone Colin B · West Glacier, MTN5242ZLund Thomas S · Boulder, CON52432Aftcloud Inc · Ontario, CAN52436Angel Aviation Inc · Peoria, AZN52438Rick Aviation Inc · Newport News, VAN5243ECalifornia Professional Flyers Inc · Murrieta, CAN5243HKirk Douglas R · Benzonia, MIN5243LKeys Robert C · Winston Salem, NCN5243QCas Ltd · Swanton, VTRegistration expired, pending cancellationN5243RDraco Flight School Inc · Chino, CAN5243WFalcon Air LLC · Casper, WYN5243XMcclung Aerial Spraying Inc · Big Springs, NEN5243ZJinkins Richard D · Rewey, WIN52440Hap'S Air Inc · Ames, IAN52441Christiansen Aviation LLC · Wilmington, DEN5244EOpal Aviation LLC · Athens, GAN5244LGarman Daniel L · Burr Oak, KSN5244RClauson Ed P · Charlestown, RIN5244VKnucklehead Aviation LLC · Cedar City, UTN5244XFrantz William T · Wasilla, AKN5245KPerun Av LLC · Cliffside Park, NJN5245VMarianas Air Transfer Inc · Saipan, MPN5245WSwartzfager Lee C · Corry, PAN52465Clutter Mark R · Spencer, OHN5246LSmithson Thomas E · Franklin, TNN5246MFlorida Aviation Career Training Inc · Saint Augustine, FLN5246QEast Hill Flying Club Inc · Ithaca, NYN5246UMize Helicipter LLC · Edmond, OKN5246WScovil Jarin K · Laramie, WYN52473American Patrols Inc · Midland, TXN52474Stearman Pilots LLC · Gilroy, CAN52476Good Guys Flying Club LLC · Colorado Springs, CON5247RHarbour Aviation LLC · Weatherford, TXN5247TTevik Michael A · Provo, UTN5247XTexas Skies Flight School LLC · Boerne, TXN5247ZBard Alexander T · Portland, ORN52483Walsh Air Enterprises · Sugar Land, TXN52489Cardinal Club Llp · Fargo, NDN5248TDopfel Sierra M · Udall, KSN5248UStephens Robert Z · Missoula, MTN5248WBalfa Joshua · Lumberton, TXN5248ZTurner William J · Twentynine Palms, CAN52493Lasky Matthew T · Constable, NY
Back to AD 90-04-06 R1