AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N285EASouth Carolina Forestry Commission · Columbia, SCN285EJCounce Mitchell K · Goodyear, AZN285HGeorge Gary D · Humble, TXN285HABlacqjacq Aviation Co · Wilmington, DEN285HCStiller Mark R · Anchorage, AKN285HPGaines Robert M · Nashville, TNN285JACarroll Aviation Inc · Carroll, IAN285JSFlytruckeetahoe Inc · Truckee, CAN285MKPlane Nonsense Inc · Middletown, DEN285PDennin Michael E · Minden, LAN285PEBravo Leasing LLC · Daytona Beach, FLN285QAdams Aircraft LLC · Wilmington, DEN285RGMf Helicopters LLC · East Troy, WIN285TARegistration Pending · Augusta, KSRegistration pendingN285TCSickinger Alan W · New Philadelphia, OHN285THAtp Aircraft 2 LLC · Wilmington, DEN285VNElizabeth City State University · Elizabeth City, NCN285WAN285wa LLC · Carthage, NCN285WY46u LLC · Anaconda, MTN285ZAlpha Tango Aircraft LLC · Wilmington, DEN28604Quest Technical Sales & Marketing Inc · Westlake Village, CAN2860FSullivan Stanley D · South Jordan, UTN2860KWolfe Don · Foresthill, CAN2860PSchwend Brian · Forsyth, MTN2860QLawton Metropolitan Area Airport Authority · Lawton, OKN2860RStoddard Bruce R · Tucson, AZN2860TSchmitz Nicholas S · East Lyme, CTN2860ZCarter Harold · Elizabethton, TNN28610Brown Ryan O · Columbia, TNN28614Cae Aviation Academy Phoenix LLC · Mesa, AZN28618Morgan Robert J · Mojave, CAN2861FProair LLC · Dayton, IDN2861QBlackmon Robert · San Antonio, TXN2861TDesert Sky Flight Group Inc · Tucson, AZN2861WAustin And Austin Inc · Stafford, KSN28622Cole Quentin P · Huntingdon Valley, PAN28627Key City Fliers Inc · Maquoketa, IAN2862APrecious Heir Holding Company LLC · Tucson, AZN2862FFoxtrot Partners LLC · West Bountiful, UTN2862PTexas Amphibians LLC · Braunfels, TXN2862RGuthrie Devin L · Sallisaw, OKN2862TReed Thomas F · Maize, KSN2862WBonanza 62w LLC · Richmond, INN2862XMathews Nancy M · Englewood, TNN2862YDickson Troy S · Placerville, CAN28630Flying Tiger LLC · Chesapeake, VAN28631Perry Colin C · Petaluma, CAN28633Fritz William J · Carnesville, GAN28634Wolvin Michael S · N Fort Myers, FLN28635N28635 LLC · Harding, PA
Back to AD 2007-04-19 R1