AD 72-03-06
Registered aircraft · 758
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:72-03-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-06')
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:72-03-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-06') 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.
N122JLotus Aviation LLC · Boring, ORN123MGHagedorn Aviation Inc · Columbus, OHN123NMAglk LLC · Lewes, DEN124EHJbp Aviation LLC · Henderson, NVN124PDH & O Helicopters Inc Trustee · Wilmington, DEN126KWHlh Leasing LLC · Wilmington, DEN12AAAllsouth Aviation LLC · Buford, GAN12BFHutter Charles G · Carson City, NVN12SPNew York State Police · Albany, NYN12THHarding Tim · Bryan, TXN130BHObrien Helicopters Inc · Lehigh Acres, FLN130JHRanger Aviation Leasing LLC · Wilmington, DEN131AEAtwood Aviation LLC · Pickerington, OHN137AGTop Gun Precision Ag LLC · Skidmore, TXN137HSHelicopter Services Of Illinois LLC · Fisher, ILN13KJCarlston Carl Vaughn · Murray, UTN142CCMachinery Service Co Inc · Wiscasset, MEN146ETFour Creeks Aviation Inc · Visalia, CAN146SHScott'S Helicopter Services · Le Sueur, MNN14807Hammock Flying Service Inc · Smithville, ARN14837Oscar Aerial Spraying LLC · Grady, OKN150AGInternational Air Services Inc Trustee · Carson City, NVN150F11 11 Enterprises LLC · San German, PRN152CAChem Air LLC · Shreveport, LAN153SAHodges Terry A · West Branch, MIN157BAAirmart Inc · Lexington, KYN158DWSolamente Air LLC · Fort Wayne, INN15THHeliservice LLC · Wilmington, DEN16002Commonweath Of Massachusetts · East Boston, MAN1602LSaxton Helicopter Leasing LLC · Plymouth, MIN1604ZDept Of Fish Wildlife And Parks · Helena, MTN16050Venturi Aviation LLC · Missoula, MTN16062Flight Inspection LLC · Springdale, WAN16069Paragon Air Group · Fort Worth, TXN1610BBlackstead Investments Inc · Boise, IDN1612Gm Leasing Co LLC · Broussard, LAN162SHCastro Be LLC · Wilmington, DEN164KMemphis Police Department · Memphis, TNN164RLRotorcraft Leasing Company LLC · Broussard, LAN165JKBohica Consulting Services Of Nevada Inc · Boulder City, NVN166MBHelicopter Roundup Service LLC · Nephi, UTN16715Cahaba Forestry Services LLC · Flowood, MSN16EYCarleton Inc Trustee · Wilmington, DEN16JDTriple F Flying Inc · Benton, PAN16QRegistration Pending · Fredericksburg, VARegistration pendingN170SSOlathe Spray Service Inc · Olathe, CON171WHWestwind Helicopters Inc · Santa Fe, TXN173SJAnthony Ghidossi Chemical LLC · Marysville, WAN174ECBingham Larry F · Juneau, AKN175HAShearer John · The Dalles, OR
Back to AD 72-03-06