AD 71-13-01 R1
Registered aircraft · 6,915
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.
N21ABAriel J Quintela LLC · Odessa, FLN21AGGronemeyer Jens · Deland, FLN21AQCapiga Daniel P · North Fort Myers, FLN21HGDrisco LLC · Ponca City, OKN21HLChieftain Aviation Inc · Marietta, GAN21NCBearing Tree Land Surveying LLC · Oklahoma City, OKN21VTCle Aviation LLC · Palm Beach Gardens, FLN21WDMullens Aviation LLC · Estero, FLN2200FQualitair LLC Trustee · MichelstadtN2202NAlcyone Trust Corp Trustee · Wichita, KSN2205PSignature Properties Of Litchfield Inc · Murrells Inlet, SCN2208ALance Eight Alpha LLC · Terre Haute, INN2209HLynxaviation LLC · Carpinteria, CAN2209TSngdo Aviation LLC · Spring Hill, FLN220BCRock Creek Leasing LLC · Sapulpa, OKN220LLife Chiropractic And Wellness Center Inc · Prudenville, MIN220RMBenner Gregory T · Youngsville, NCN220WJaw Air LLC · Fargo, NDN2210QSymphony Air LLC · Medford, NYN22117Von Ahlefeldt Alan R · Parker, CON22136Zest Fest Corporation Of Oregon · San Diego, CAN2213NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN221ACAusten Air LLC · Lees Summit, MON221CATripp Charles A Jr · Brownsville, TNN221CSTriple Seven Aviation LLC · Newark, DEN221DWDm Private Aviation LLC · Kaukauna, WIN221GHWitham Aviation LLC · Stuart, FLN221GSBarientos Bryan I · Petaluma, CAN221JTThompson Joseph · Marion, INN221STForza Management Co · Auburn, MAN221WGLove Kenneth J · CombaningnswN22206Slater Craig W · Brick, NJN2220EBerry Islands LLC · Holly Hill, FLN2220JTrj Aero Holdings LLC · Tequesta, FLN22213Stemmer Kenneth Edward · Palm Desert, CAN2221GWs Management Of Tyler LLC · Shreveport, LAN2221XK C Leasing Corp · Woods Cross, UTN22262Oldenkamp David J · Payson, AZN2228THulsey Hunter · Madison, MSN22293Jacobson Duane A · Marco Island, FLN22295Poole Frederick J · Meridian, MSN222FGoddspeed LLC · Encinitas, CAN222FS404 Church LLC · Wayne, PAN222HMAmerican Saddlair LLC · Park City, UTN222JLThomas Kent C · Muncie, INN222KHPavco Inc · Gig Harbor, WAN222KWHines Tommy · Calvert City, KYN222LEHigh View Air LLC · Driftwood, TXN222MMYount Patrick G · Buckeye, AZN222PPPreferred Landing LLC · Tomball, TX
Back to AD 71-13-01 R1