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.
N62802Hannair LLC · Titusville, FLN62807Neal Aircraft Inc · Slaton, TXN62808Wings Over Texas Holdings LLC · Denton, TXN62812Facer Insurance Agency Inc · Rantoul, ILFirst renewal noticeN62818Pollack Matthew · Falls Church, VAN6281ZLawrence John · Portland, ORN62828Benchmark Farm Management Inc · Riverbank, CAN6282JLutter James L · Gann Valley, SDN62835Paperd Rex A · Fall City, WAN62836Pacific Fleet Aviation LLC · Rochester, NYN62840Emond Ronald L DBA · Nashua, NHN6284SNorth Dakota Aeronautics Commission · Bismarck, NDN62869Brown Henry H · Prospect, KYN6286KKomko Randy M · Mckenna, WAN62899Sf Health Solutions Inc · Homestead, FLN628BHelsley William W · Mc Gaheysville, VAN628GVClark R Judson · San Luis Obispo, CAN628HADigital Mapping Inc · Huntington Beach, CAN6290XDelcor Electronics Inc · Mount Vernon, NYN62912Gross Charles C III · Mims, FLN62923Gv Air Inc · Medford, ORN62926Peterson Business Promotions LLC · Portland, ORN6292HRkd Illinois Aviation LLC · Libertyville, ILN6292JVan Bortel Aircraft Inc · Arlington, TXN6294YCarlson Ernest C Jr · Fairbanks, AKN6296RAerospace Trust Management LLC Trustee · Wilmington, DEN62992Light & Variable LLC · Arlington, VAN6299YT&T Aviation LLC · Clarksville, TNN629BAKqm Aviation · Bristow, VAN629BDNby Productions · Bristow, VAN629CDrc Aviation Of Stuart LLC · Palm City, FLN629DKUnited Steel Erectors Corp · Atlantic, IAN629LHJbiz Aviation LLC · Las Vegas, NVN629RMW J Halberstadt Transportation Inc · Hartland, WIN629RSObr Leasing · Bristow, VAN629STHolokai LLC · Boyes Hot Springs, CAN629TALudwig Adrian Trustee · Truckee, CAN62ADHawkins Flight Academy LLC · Shelbyville, TNN62BPPecan Aviation LLC · Granbury, TXN62CASchoenle Paul D · South Bend, INN62GWGoshen Wings Inc · Bristol, INN62LLAirborne Research LLC · Fort Pierce, FLN62LNDeeds Little Corp · Wilmington, DEN6300MShortfin Holdings LLC · Seneca, SCN6300YSullivan Mark F · Cocoa Beach, FLFirst renewal noticeN6303VMiles Vernon · Cordova, TNN630ACHollandall LLC · Florence, KYN630ESJez Farms LLC · Mattoon, ILN630KBKilo Bravo LLC · Saratoga, CAN630KCCentral Airlines Inc · Leawood, KS
Back to AD 71-13-01 R1