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.
N3191JPhillips Nicholas H · Mikana, WIN3191RLv Aviation LLC · Pompano Beach, FLN3191SSkydive Harbor Springs Inc · Charlevoix, MIN3191THappy Landings Aviation LLC · Maple, NCN3191UWings Of Hope · Chesterfield, MON3192CHansen Leland K · Phoenix, AZN3192JWestern Altitude LLC · Dayton, MTN3192QSeel Jason L · Oak Creek, WIN3192RFuchs Robert D · Easton, PAN3192SFrandsen Perry D · Sandy, UTN3192THawley James W · Waddell, AZN3192UColonial Aviators LLC · Williamsburg, VAN3192YArea 52 Aviation LLC · Casper, WYN3193DOrth Henry J · Wasilla, AKN3193FJcd4 Capital LLC · Birmingham, ALN3193JWebs James H · Alexander, KSFirst renewal noticeN3193RHolmes John H · Barto, PAN3193SHansen Arthur A · Lancaster, NYN3193VFly Sky Ads LLC · Manalapan, NJN3193YDavis Loyal A · Santa Rosa, CAN3194DMatthews James B · Wills Point, TXN3194YSchexnayder Jennifer · New Roads, LAN3195DRegistration Pending · Fort Mohave, AZRegistration pendingN3195ECatlett John W · Briggsville, ARN3195MAspire Management Inc · New Castle, DEN3195RPalmer Matthew B · Riverside, CAN3195UHinton Jake B · Mcdonough, GAN3195YFlyers Above The Payette LLC · Mccall, IDN3196CWeir Ryan L · Buckley, WAN3196RS & S Aviation Co · Ball Ground, GAN3196SHistoricair Transport LLC · Midlothian, TXN3196TNicholson Perry R · Merlin, ORN3196XFroes Carlos Da Lapa · Avondale, AZN3196YRickles Richard J · Chamblee, GAN3197CScott James D · Mesa, AZN3197FWhite River Land And Timber Co LLC · Greenbrier, ARN3197SJarvis Jason O · Cresson, TXN3197TMundle Jeffrey A · Ashland, ORN3197XLynn Christopher M · Hood River, ORN3197YMonahan Robert J · Bulverde, TXN3198FDepinet Rodney J · Glen Saint Mary, FLN3198JAlternate Air Inc · Seattle, WAN3198YKembel Cary A · Snyder, CON3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeN3199RUmina Michael P · Hopkinton, MAN3199TMortgage Experts LLC · Homestead, FLN3199UNiner Niner Uniform LLC · Elk Mound, WIN3199VDs Victor LLC · Elburn, ILN3199XClark Terry E · Dixon, MON3199YClearwater Valley Aero Club Inc · Kamiah, ID
Back to AD 97-01-13