AD 90-02-13
Registered aircraft · 3,863
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-02-13')
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-02-13')
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-02-13') 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-02-13') 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.
N19LFN19lf Corp · Oak Lawn, ILN19STS&S Aviation Co · Ball Ground, GAN1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedN1QMAhlhorn Travis W · New Braunfels, TXN1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYN1YCMay Thomas W · Texarkana, TXN200BNRubber Duck Aviation LLC · Brunswick, GAN200DCBjg Aviation I LLC · Neelyville, MON200GCDancy Abram P · Shrewsbury, MAN200LEAeromarine Holdings LLC · Waukesha, WIN200MCN200mc Inc Trustee · Cheyenne, WYN200SHHoward Steve · Jefferson City, MON200TNI & V Aviation LLC · Missoula, MTN200YCShady Aero LLC · Anchorage, KYN20162Wateractive43 LLC · Auburn, CAN202AASimply Living LLC · Fort Myers, FLN202DBClipper Air LLC · Cresson, TXN202SWMar Jar LLC · Gilmer, TXFirst renewal noticeN202ZLojas Phillip · San Ysidro, CAN203BNCarlson Curt · Lake Havasu City, AZN203JLJfra LLC · Miami, FLN204KMInternational Air Services Inc Trustee · Carson City, NVN205CAHyannis Air Service Inc DBA · Hyannis, MAN208VBas Part Sales LLC · Greeley, CON209DCDelaware Corp · Topping, VAN20HKGill John H · Woodway, TXN20JNGana Trucking & Excavating Inc · Martell, NEN20MWStriebel David J · Dayton, OHN20NGTas Aviation Of Defiance Inc · Defiance, OHN20VKEvans Jeffrey L · Mansfield, LAN20WAOn Air Company LLC · Sewickley, PAN20WFLofton Christopher L · Harlingen, TXN210FCBaked Industries Inc · Yuba City, CAN211SVMatthews Aviation LLC · Greensboro, NCN21234Positive Rate LLC · Kenosha, WIN212RVMinuteman 12 LLC · Wilmington, DEN213JDS&C Vending LLC · Scottsbluff, NEN21430Burns Preston · Spruce Pine, ALN214CCSteele Aviation LLC · Tuscaloosa, ALN214DFGaylord Hangars LLC · Gaylord, MIN214WGriffeth John · Branson, MON215AMurphy Dan A · Two Harbors, MNN215CBKw Bradley Associates LLC · Manlius, NYN215MPPersson Timothy J · Kansas City, KSN216LBBail Air LLC · Port Saint Lucie, FLN217BSRegistration Pending · Nogales, AZRegistration pendingN218CFLevel 200 LLC · Charlottesville, VAN218USouthern Aircraft Consultancy Inc Trustee · Casper, WYN2199CMorris Thomas B · Imlay City, MIN21CSHendrix Peter A · Plantation, FL
Back to AD 90-02-13