AD 75-09-13
Registered aircraft · 4,787
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:75-09-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:75-09-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:75-09-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:75-09-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.
N4372BTyler Hendry Dds Inc · Glendale, CAN4372EPad Aviation LLC · New Castle, DEN4372LSteen Douglas S · Cresson, TXN4376APeavy Ricky Tod · Gainesville, GAN4377ATebeaux William Jene · College Station, TXN4380DLivengood Leasing Co LLC · Mesa, AZN4380S9791m LLC · Tacoma, WAN4386NFreedom Airplane Jv 1 LLC · Pensacola, FLN4387DTravel Direct LLC · Montevideo, MNN4388MMalibu 88mike LLC · Duncanville, TXN438APWhiskey 340 LLC · Tucson, AZN438EL1 Stop Sod & Landscaping Inc · Orlando, FLN43911Scud Runner LLC · Cape Coral, FLN4391EN4391e LLC · Scottsdale, AZN43BMDodson International Parts Inc · Rantoul, KSN43CPMountain View Industries LLC · Missoula, MTN43DAAero Management Holdings LLC · Hot Springs, ARN43KTTowles Michael D · Corona Del Mar, CAN43KYPinto Carlos Eduardo · Tucson, AZN43MEEvans Matthew B · Granbury, TXN43MRFlight Contract Services Inc · Las Vegas, NVN43QCAviation LLC · Kalispell, MTN4402JBruton Paul · El Campo, TXN440DL421 Partners LLC · Crown Point, INN440LJByington William · Minden, NVN4414RKirk Ledoux · Stanwood, WAN441TPUnited Contractors Inc · Costa Mesa, CAN441TTSunbird Airlines Inc · San Juan, PRN4421RJ & B Aircraft Leasing LLC · Lufkin, TXN4422NValiair Lc Trustee · Casper, WYN4428CPayne Jeffrey C Trustee · Stockton, CAN4429LShingebiss LLC · Independence, ORN442CCRaymond Andrew A · Crescent, IAN442FMHogan Quinn H Trustee · Milwaukee, WIN443RSalinas Construction Technologies Ltd · Pleasanton, TXN4440KKate & Jennifer Airlines LLC · Tampa, FLN44463Sabine Financial Services Inc · Wilmington, DEN444ATCore Aviation LLC · Dayton, OHN444BGMitchell Aviation LLC · Mitchell, SDN444BSSiemens Christopher L · Seminole, TXN444BZWilliams Allen G Jr · Fort Worth, TXN444DMGosnell Josh W · Richards, TXN444DTBagdasarian Walter DBA · El Cajon, CAN444FRegistration Pending · Auburn, CARegistration pendingN444FCCentric It Resources LLC · Loomis, CAN444HTTaktos Ltd · Corvallis, ORN444JMPeck Joseph A · Pound Ridge, NYN444KTHangar G-1 Aviation Partners LLC · Los Olivos, CAN444KWRaw Racing Inc · Puyallup, WAN444LSTaa Property LLC · Lake Wales, FL
Back to AD 75-09-13