AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N3259JPreflight Aviation Inc · Oregon, WIN3259RGlobal Marc Aire Inc · Dallas, TXN3259UMoore Christopher · Canton, PAN3259VMaynard Richard L · Vilonia, ARN3259YGrantham William Edward · Doerun, GAN325JSAbbott Bruce E · Seal Beach, CAN325KCMount Wilson Holdings LLC · Orange, CAN325RPN325rp Corp · Willow Spring, NCN325UKilo Fox Aviation LLC · Saint Joseph, MIN326Nardi Greg · Missoula, MTN3260LHerring Rhett H · College Station, TXN3260SAbner Aviation LLC · Advance, NCN3260YOneal Gary · Springdale, ARN3261DCastorina John Salvatore · Anthem, AZN3261SBig Island Gravity LLC · Kapaau, HIN3262JBlock Oliver L · Nashville, TNN3262LKd3262 LLC · Downers Grove, ILN3262SIlair LLC · Manassas, VAN3263JCorrigan Air Center LLC · Hondo, TXN3263LSale Reported · Arcata, CASale reportedN3263SBynum Albert L · Gadsden, ALN3264JB&K Used Auto & Equipment Llp · Fountain Run, KYN3264QWilton William H · Kailua Kona, HIN3264TVan Iderstyne Richard D · Jekyll Island, GAN3265DMiller Matthew S · Washougal, WAN3265ETa Brand LLC · Middletown, DEN3265JFord-Umfuhrer Austin Donavan · Carrollton, GAN3265SZehntner David R · Labelle, FLN3265UPreissler Daniel E · Giltner, NEN3266EN3266e LLC · Homestead, FLN3266LWolverine LLC · Roanoke, VAN3266UVingers Michael T · Dellwood, MNN3267DDavidson Danny F · Anchorage, AKN3267LBetter Fly Inc · Litchfield, ILN3268CLane Ryan Auctions LLC · Palmyra, PAN3268JMiller Robert F · Locust Grove, GAN3268KRegistered aircraftN3268QSuperior Food Distributors LLC · Naples, FLN3268SSquier Mark R · Lake Dallas, TXN3268TKawsara Sabah M · Fort Worth, TXN326AMAviatzone LLC · Fort Lauderdale, FLN326PTJt Aero LLC · Covington, GAN3270DMcbride Robert W Jr · Cedar Park, TXN3270UScott Brian W · Sagle, IDN3271LHenson Raul Andre · Fox Island, WAN3271UDallas Avionics Inc · Dallas, TXN3271YWoodbury Ivan D · Bowling Green, OHN3272TSonoras John G Jr · Newport, MIN3272YOlsen Chris M · Othello, WAN3273DMonitor Ventures Group LLC · Anaheim, CA
Back to AD 97-01-13