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.
N303KSSmoky Hill Ag LLC · Healy, KSN303LKWestwind Aviation Inc · Bremerton, WAN303MBBas Part Sales LLC · Greeley, CON303PBPlane Fun Inc Tr Trustee · Snellville, GAN303RJTr Zato Heir Land & Cattle LLC · Spur, TXN303SDHarris County Sheriff'S Office · Spring, TXN303WAWacker Logistics LLC · Naples, FLN303WJQualitair LLC Trustee · MichelstadtN303WWQualitair LLC Trustee · MichelstadtN303XStocki Ronald W · Centennial, CON30404Cardinal Flyers LLC · Powell, OHN30407Cardinal Cronies LLC · Clarinda, IAN30409Schmitt Cameron · Fort Dix, NJN3040FJump Tn LLC · Greeneville, TNN3040JCrabtree Steven B · Canyon, TXN3040SPearson Wayne L · Fayetteville, ARN3040VFlight Deck Air And Sea LLC · West Palm Beach, FLN3040YRight Rudder Flyers LLC · Columbia Falls, MTN30413Eagle Sky Patrol Inc · Deadwood, SDN30418Young Matthew B · Brighton, ILN3041FRoffey Edward P Trustee · Grand Junction, CON3041UMoser Paul J · Danville, PAN3041XSky Partners LLC · Sylacauga, ALN30422Casey Michael B · Hemingford, NEN3042FTdc Aviation LLC · Scottsdale, AZN3042JHutchison Robert T · Big Lake, AKN3042XMariani Nut Co Inc · Winters, CAN30433Flying Hawks Inc · Palmyra, WIN30436Carson Charles E · North Vernon, INN30437Richards David N · Port Matilda, PAN3043QDerango Gregory J · Chitina, AKN3043XVaughan John T · Safety Harbor, FLN30441Gillenwater Timothy J · Glasgow, KYN30443Songer Harvey · Beech Grove, ARN30444Crapnell Mark · Huntington Beach, CAN30446Gumz Terry J · Wailuku, HIN3044QParrow Ronald J · Hampton, CTN30450Recker Timothy J · Aurora, IAN30458Spires William B · Minden, NVN3045FFinley Eric · Ione, CAN3045QLong Randy B · Coleman, TXN3045UAfterburner Aviation LLC · Lewes, DEN3045VBuck Quincy M · Lakeville, MNN30463Chambers Frederick J · Lake Forest, CAN30464Cunningham Augustus Bruce · Madison, ALN3046FPlane Brilliant · Odessa, FLN3046JDyer David A · White Hills, AZN3046QN3046q LLC · Colorado Springs, CON3046SWhite William E · Watkinsville, GAN30474Ross Richard R · Jerseyville, IL
Back to AD 97-01-13