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.
N2812LHarris Partnership · Conway, ARN2812QHammond David J · Chesterfield, VAN2812RBullin Keith · Bryan, TXN2812UBas Part Sales LLC · Greeley, CON2812XHarris Rodger C · Titusville, FLN2813FDan Air LLC · Greenville, SCN2813LFoster Neal W · Nome, AKN2813QOriginal Design Ministries · Eatonville, WAN2814KMacario Mark A · Weirsdale, FLN2814LStewarts Aircraft Service Inc · Waynesville, OHN2814QGill Robert L · Dixon, CAN2814RCypress Aviation Inc · Naples, FLN2814VCentral Ohio Soaring Association · Marion, OHN2814YYankee Tango Mike LLC · Dublin, TXN2815KStudniski Alois W · Saint Joseph, MNN2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSN2815TNorwest Ventures LLC · Sagle, IDN2815UHarris Tony James · Stanley, NCN2815YFlakes LLC · Fort Worth, TXN2816KVigna Douglas Del · Portland, MEN2816XCoats Christopher · Vinita, OKN2817ARamey Shane · Buffalo, WYN2817C2817c Inc · Wilmington, DEN2817UAero Ventures Inc · Yukon, OKN2818DSlodki David · Massapequa Park, NYN2818ESale Reported · Lexington, NCSale reportedN2818FMccullough Andrew · Lubbock, TXN2818UWard Jasper Eugene · Telford, TNFirst renewal noticeN2818YEaton Melvin W II · Saint Onge, SDN2819QAirborne LLC · Wilmington, DEN2819SBeale Frank B II · Bowling Green, VAN2819UGartner Thomas M · Newton, KSN2819XPope Steven R · Gilbert, AZN281PMPlanemasters Ltd · West Chicago, ILN281SLCurly Aviation LLC · Atlanta, GAN281UDStanley David Wayne · Burleson, TXN2820LHarrington Thomas W Jr · Cumming, GAN2820QBush Steven B · Lago Vista, TXN2820RHutter Karl G · Reno, NVN2820XJones Michael S · Fremont, WIN2821ALewton John E · Belgrade, MTN2821K4608 Vista LLC · Fort Lauderdale, FLN2821QHattan Richard A Trustee · Fairbanks, AKN2821RNielson David L Trustee · Anchorage, AKN2821SHancock Jeffrey A · Jacksonville, TXN2821UPelotte Raymond J · Waterville, MEN2822LRobertson IV Henry B · Owensboro, KYN2822MWendt Robert R · Sedona, AZN2822XPender Michael J · Marsing, IDN2823AMckinney Eric S · Hamersville, OH
Back to AD 97-01-13