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.
N44VKBates Management Inc · Woodstock, GAN44VTNelson William R · Caldwell, IDN44VVHampton Warrior II Inc · Shelter Island, NYN44WCWhite Eagle Investments LLC · San Jose, CAN44WDDemray William S · Northville, MIN44WFWildy David · Manila, ARN44WHKelly Sean R · Bozeman, MTN44WKMaiden Robert M · Williamson, GAN44WLLitton Wade N · Townsend, MTN44WMBloomfield Robert C · Anchorage, AKN44WPAnderson Stuart R Jr · Sahuarita, AZN44WTMoore Arlon A · Newcastle, CAN44WXA O Retail Consulting Inc · Oconomowoc, WIN44WZWild Blue Yonder LLC · Batavia, OHN44XBBrennon Aviation LLC · North Fort Myers, FLN44XCSendero Helicopters LLC · Bandera, TXN44XDDuffer David · Fallbrook, CAN44XFWetzel Jack T · New Port Richey, FLN44XHPelican Island Air Leasing Inc · Bryson City, NCN44XJRegistered aircraftN44XXFlyboy71 LLC · Kalamazoo, MIN44YHansen Kenneth · Irvine, CAN44YAAarow Aircraft Leasing LLC · Mcminnville, ORN44YDYule Development Co Inc · Newton Center, MAN44YGAppelt Jon A · Dayton, NVN44YNG A Clipper Helicopter Inc Trustee · Wilmington, DEN44YTJohs Robert W · Palacios, TXN44YUDoane Mica S · Meno, OKN44YYYankee LLC · Kasilof, AKN44ZMSchnurbusch Larry · Saint Louis, MON44ZWTurner Robert H · San Diego, CAN4500BStartin Brandon Lee · Spokane, WAN4500KEaston Gregory D · Montrose, CON4500RWork Edward · Sneads Ferry, NCN4500WMagalsky Jacob J · Wilsall, MTN4501EOptima Aviation LLC DBA · Lewisville, TXN4501HBrown Kevin · San Dimas, CAN4501JBleem Steven L · Duncan, OKN4501RNess James H · Phoenix, AZN4501SDecuir Mark A · Cottonport, LAN4502BAshcraft Dustin William · Anchorage, AKN4503JSkykid Adventures LLC · Cedar Valley, UTN4503SBarber Christian · Mansfield, MAN4503YSteppler Dean M · Culbertson, MTN4504SRegistered aircraftN4504YCronin Monty A · Gettysburg, SDN45050Rav Aviation LLC · Miramar, FLN4505ASteadman Norman W · Arlington, TXN4505RFayal Kenneth E Jr · Bend, ORN4505SGo Flyers LLC · Sudbury, MA
Back to AD 2007-04-19 R1