AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N443RSalinas Construction Technologies Ltd · Pleasanton, TXN4440KKate & Jennifer Airlines LLC · Tampa, FLN4441VKilo Tango 716 LLC · Carlisle, PAN4441WHodge Henry D Jr · Anchorage, AKN44463Sabine Financial Services Inc · Wilmington, DEN444AHPhalanx Pc LLC · Austin, TXN444ANJmr Air LLC · Spokane, WAN444BSSiemens Christopher L · Seminole, TXN444BZWilliams Allen G Jr · Fort Worth, TXN444CVCloud Punchers LLC · Cary, NCN444DMGosnell Josh W · Richards, TXN444DTBagdasarian Walter DBA · El Cajon, CAN444FRegistration Pending · Auburn, CARegistration pendingN444FCCentric It Resources LLC · Loomis, CAN444GCCampbell Gregory A · Davis, ILN444HKChurch David H · Albuquerque, NMN444HTTaktos Ltd · Corvallis, ORN444JHCirrusly Fast J2911 LLC · Duson, LAN444JMPeck Joseph A · Pound Ridge, NYN444KKHeartland Tank LLC · Ponca City, OKN444KTHangar G-1 Aviation Partners LLC · Los Olivos, CAN444KWRaw Racing Inc · Puyallup, WAN444LFBourbon Richards LLC · Tempe, AZFirst renewal noticeN444LSTaa Property LLC · Lake Wales, FLN444MFChampagne Cruises Ltd · St Thomas, VIN444NPJc Aviation LLC · Raleigh, NCN444PGN444pg Aviation LLC · Charleston, SCN444PTCirrus Design Corp · Duluth, MNN444RSRomeo Sierra Aviation LLC · Gilbert, AZN444RWBackus Gary Carl · Chesapeake, VAN444SRr&D Lp · Fayetteville, NCN444UJAmbush Aviation LLC · Anabel, MON444VPBalzer Joseph W · Sevierville, TNN444VRBarber Casey John · Visalia, CAN444WELiberty Steaks LLC · Latham, NYN444XDAshanti Aviation LLC · Flemington, NJN4455Sanders Russell · Canton, GAN4458SCn Aviation LLC · Mesa, AZN445CDMockingbird Wings LLC · Wilmington, DEN445HPChopra Family Lp · Tulare, CAN445MLCirrus Sr22t 8876 Inc Trustee · Wilmington, DEN445PWelsh Steven M · Oxford, NCN4466LSmyrna Aviation LLC · Edgewater, FLN4468FIdahi Aviation LLC · Eagle, IDN446BDAircraft Guaranty Corp Trustee · Oklahoma City, OKN446CPOn Eagles Wings Aviation LLC · Ponte Vedra Beach, FLN446DMRegistration Pending · Austin, TXRegistration pendingN446FMProspect Aviation LLC · Puyallup, WAN446HBAerozap Ventures LLC · Sartell, MNN446HDSpace Change You LLC · Destin, FL
Back to AD 2012-10-13