AD 83-10-01
Registered aircraft · 1,036
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:83-10-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-10-01')
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:83-10-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-10-01') 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.
N400PPMig Aviation LLC · Sandy, UTN400SWDay Stephen F · Queen Creek, AZN400TDHardy Mikel · Twin Falls, IDN400WGRegistered aircraftN400WLHammer Construction Corp · Miami, FLN400YKarschney Rich · Seattle, WAN40439Usoarflorida LLC · Fort Myers, FLN405TSRichard N Appling · Ellensburg, WAN407AFRuff Brent M · Santa Clarita, CAN40DACirrus Design Corp · Duluth, MNN40VMQualitair LLC Trustee · MichelstadtN40WFGrennell Brian M · Euless, TXN415HPRichmond George H Jr · Elkhorn, NEN41BPSturdevant Harold L Jr · Kalispell, MTN41PLTj Air Holdings Inc Trustee · Wilmington, DEN4269WZeek Michael · Munfordville, KYFirst renewal noticeN4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN42PMJofredo Corp · Zephyrhills, FLN42TPBalkin John S · Bigfork, MTN43BLockard Seth J · Lebanon, TNN444CPMercure Ryan K · Eads, TNN44WDDemray William S · Northville, MIN45JLBows Investments LLC · Bend, ORN46EAEssential Aviation LLC · Meridianville, ALN4743MMcbride Paul · Dallas, TXN475TVPaine Twin Comanche LLC · Redmond, WAN48086Spohrer Wilner And Maxwell P A · Jacksonville, FLN48ARGacey Inc Trustee · Wilmington, DEN4949YPearce Richard Henry · Moses Lake, WAN494NJT And B Flying Adventures LLC · Middletown, DEN49WSJohnson Matthew N · Redgranite, WIN4CKLorenzo Walker Institute Of Technology · Naples, FLN4YASoaring Eagle Southwest LLC · Fort Mohave, AZN501REIndependence Aerospace LLC · Kennesaw, GAN502DWSolamich Aviation LLC · Huntley, ILN505GAlford Robert S · Columbus, GARegistration revokedN5088CMike Golf Holdings LLC · Pinellas Park, FLN50TDPa-30 LLC · Appleton, WIN518CMTreakle Robert W · Austin, TXFirst renewal noticeN537DMKrakoff Matthew · Massapequa, NYN555NSN8241r LLC · Leawood, KSN55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN55RDSchober David · Union Bridge, MDN566BSSand Farm Management Services LLC · Adel, IAN567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationN57DJPasserby Randal K · Mesa, AZN597LDewitt Troy C · Lake Elmo, MNN5BYWolff Emanuel C Md · Tucson, AZN5EBN5eb LLC · Medina, OHN5MAScola Daniel B · Port Orange, FL
Back to AD 83-10-01