AD 71-13-01 R1
Registered aircraft · 6,916
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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.
N8597PIsbell James R · Denison, TXN859ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYN859RGVan Bortel Aircraft Inc · Arlington, TXN85CPN85cp LLC · Edmond, OKN85DJRegistered aircraftN85DLDelta Lima Inc · Justice, WVN85ESProsser Rodney W · Columbia, NJN85HGJwp Group LLC · Long Island, MEN85QAmiculum LLC · Black Eagle, MTN8603PComanche Flyers LLC · Jefferson Township, PAN8606PBuhler Carey C · Mitchell, SDN8608PLane Vaughn S · Gonzales, LAN860DMC & C Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeN860FGCapital Holdings 299 LLC · Edwards, CON8610PTapert Warren F · Lenox, MIN8612PFranz James T · Glendale, AZN8614NFarmers Bank Of Northern Missouri Na · Unionville, MON861DPPoage Equipment LLC · Amarillo, TXN8621NMcdonald Timothy Shane · Saint Jacob, ILN8622NPapp Adam P · Raleigh, NCN8623PMajor Development LLC · Cedaredge, CON8625NJanicke Clayton R · Bird City, KSN8626NCf Aviation LLC · Wellington, FLN8629NN8629n Inc · Ooltewah, TNN862ARLe Pichon II LLC · San Juan, PRN862STFoxtrot Lima Enterprises LLC · Elbridge, NYN8630NLowe Alexander · Wauwatosa, WIN8630PSpanjer Blake L · Crete, NEN8631NOwen Toy C · Anchorage, AKN8632PCarleton Dennis M · Sewickley, PAN8634NWright David P Jr · Chandler, AZN8638PBartell John B · Elgin, ILN8639PJohnson James E · Calhoun, LAN863DRFive Up Aviation LLC · Ambler, PAN863TCTjk Aviation LLC · New Canaan, CTN863WAK Bear Holdings LLC · Bend, ORN8643PCheatwood Owen Larry · Granbury, TXN8649PMelodia Sean M · Cranberry Township, PAN8652NDavis Rick J · Los Lunas, NMN8655PBrewster Michael L · Nipomo, CAN8658NOne Way Aviation LLC · Warner Robins, GAN8658PPannell Butch W · Spring Branch, TXN865JPVista Valley Aviation LLC · Ririe, IDN8661NLyman Jared C · Plymouth, CAN8661PEast Texas Turbines Inc · Tyler, TXN8662PPearson Trevor D · San Ysidro, CAN8663PNewman Nate · Lincoln, VTN8666NTlc Aviation Ltd · Virginia Beach, VAN8667NSky High Flyers Flying Club Inc · Holbrook, NYN8667PHeffner Christopher Jay · Williamsport, PA
Back to AD 71-13-01 R1