AD 2000-08-22
Registered aircraft · 433
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:2000-08-22')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-22')
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:2000-08-22') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-22') 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.
N4265JRatcliff Dustin · Saltville, VAN4292DUrocopters Inc · Lancaster, CAN42FFBeef Aviation LLC · Bradenton, FLN43BATerrell Bill · Port Orange, FLN451HAIron Horse Aviation LLC · Marshalltown, IAN454JHJack Harter Helicopters Inc · Lihue, HIN457GMCentury Aviation Inc Trustee · Wilmington, DEN458HWHeliwild Investments LLC · Austin, TXN458PBBarbaro Paul G · Argyle, TXN46662Brown Helicopter Inc · Pensacola, FLN469FCFerguson And Sons Construction LLC · Emmett, IDN46EEUnited States Department Of Agriculture · Cedar City, UTN473EOchoco Wood Products LLC · Prineville, ORN484Bhh Leasing #2 LLC · Pensacola, FLN48MPPope James D · Lewiston, IDN499SLHlh Leasing LLC · Wilmington, DEN49WKRail N LLC · Oracle, AZN500ARHelicopter Roundup Service LLC · Nephi, UTN500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKN500DCHva Holdings LLC · Gettysburg, PAN500EKKar Aviation LLC · Saltville, VAN500EVSnohomish County Sheriff · Snohomish, WAN500FCFerguson And Sons Construction LLC · Emmett, IDN500FFRegistered aircraftN-number assigned (import), not yet registeredN500GKN969md Inc · Middletown, DEN500HJ392e Inc Trustee · Wilmington, DEN500HWHeliwild Investments LLC · Austin, TXN500KYRotor Imaging LLC · Reading, PAN500LKWinco Inc · Aurora, ORN500MUHva Inc · Summersville, WVN500MVTreeline Helicopters Inc · Bristol, TNN500NCSanders Associates LLC · Bluefield, VAN500PHPrecision Heli-Support LLC · Mesa, AZN500RMHawkeye Helicopter LLC · Lyndon, KSN500SLPatriot Marine LLC · New Haven, CTN500SYNalas Inc Trustee · Wilmington, DEN500TNOnespan Powerline Services LLC · Peachtree City, GAN500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN500TZGulf Helicopters LLC · Santa Fe, TXN500VSVertol Systems Company Inc · Destin, FLN500WXTre Aviation Corp · Wilmington, DEN500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN501EFAirwest Helicopters Inc · Redlands, CAN501HPHonolulu Police Department · Honolulu, HIN501MDAgricultural Air Services LLC · Jupiter, FLN501RMCity Of Pasadena · Pasadena, CAN501VSVertol Systems Co Inc · Destin, FLN5027PBank Of Utah Trustee · Salt Lake City, UTN502CHVertol Systems Co Inc · Destin, FLFirst renewal noticeN502HBActive Aviation LLC · Newark, DE
Back to AD 2000-08-22