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.
N2901KFramptom Joseph B · Little Rock, ARN2901UJanes Charles D · Cleburne, TXN2901XErwin Brandon · Jacksboro, TXN2902N2902 LLC · Miami, FLN29022Unifly Inc · Lackawanna, NYN29028Service Oriented Aviation Readiness (Soar) · Bolivar, MON2902AMurray Kevin D · Moneta, VAN2902CPhil Ruhnke Construction Inc · Grangeville, IDN2902KRafter J Aviation LLC · Moab, UTN2902QHeihn Daniel M · Soldotna, AKN2902YTemple Adam C · Mitchell, ORN2903CWoodin Jacques C · Inglis, FLN2903FSawyers Ricky Dean · Tazewell, VAN2903QTwin Fiddle Investment Aeronautics LLC · Atlanta, GAN2903XBrowning Mcpherson Aviation LLC · Auburn, KYN29047State College Pilots Club · Philipsburg, PAN2904QBoley Richard J · Hayward, WIN29056Land Of Lakes Aviation LLC · Eagle River, WIN29059Ens Aviation LLC · Marshall, TXN2905ASutton Aircraft Salvage LLC · Palmer, AKN2905ECappadona Roy · Iliamna, AKN2905SCole Ezra L · Gentry, ARN2905UKear Edward B · Bonita Springs, FLN2905XRudy Schmitt · Brookshire, TXN29061Swalling Frederick M · Anchorage, AKN29068Jd Flying LLC · Bellingham, WAN2906CNewman Dan A · Oak View, CAN2906QCage James D · Muleshoe, TXN2906ULynch Lawrence C · Ladson, SCN29070Buzick Carey B · Fargo, NDN2907CPiedmont Southern Associates Inc · Clayton, GAN2907UServer William F · Sterling, MIN2908CWilliams Daniel P · Afton, WYN2908FCooprider Lee W Trustee · Littleton, MAN2908JBranton Hewett · Nashville, TNN2908SSloan Paul · Escondido, CAN2909ARasor William E · Brookville, OHN2909CHall Michael A · Spirit Lake, IDN2909SFatla Gregory F · Hixton, WIN290CAHyannis Air Service Inc · Hyannis, MAN290FCRegistration Pending · Greenwood, MSRegistration pendingN291Northern Sky LLC · Dover, DEN29107Wrong Brothers Aviation LLC · Brighton, MIN2910JWeldy Mark L · Etna Green, INN2910XTallman Richard E · Lykens, PAN29110Sutton Aircraft Salvage LLC · Palmer, AKN29114Grey Goose LLC · Wasilla, AKN2911DPagano Ralph V · Cranbury, NJN2911EAsphaltresource.Com LLC · Schwenksville, PAN2911FRegistration Pending · Fayetteville, ARRegistration pending
Back to AD 97-01-13