Skip to content

Registered aircraft · 54,019

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

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N20039Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1972 · S/N 17260952 N2003EHarman Dane P · Halifax, PABuilt 1978 · S/N 17271116 N2003GHuntley Richard W · Bellingham, WABuilt 1958 · S/N 51303 N2003Q177rg LLC · Dover, DEBuilt 1973 · S/N 177RG0403 N2003RPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1963 · S/N 18255203 N2003ZBehnken Paul · Sedgwick, MEBuilt 1963 · S/N 15059803 N20040Victor Francois · Carrollton, TXBuilt 1972 · S/N 17260953 N20041Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260954 N20045Massey Travel LLC · Ozark, MOBuilt 1972 · S/N 17260958 N20046Blue Panda LLC · Olive Branch, MSBuilt 1972 · S/N 17260959 N20047Flying Broke Acres LLC · Lexington, NEBuilt 1972 · S/N 17260960 N2004RMorasch Robert G · Walla Walla, WABuilt 1963 · S/N 18255204 N2004XCovetous Inc · Fallbrook, CAS/N 18256104 N2004ZWhiting Robert A Jr · Scarborough, MEBuilt 1962 · S/N 15059804 N20050Florida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 17260962 N20051Hayek Pierre N · Alta Loma, CABuilt 1972 · S/N 17260963 N20052Atkinson Brandon A · Pageland, SCBuilt 1972 · S/N 17260964 N20053Spanaflight LLC · Puyallup, WABuilt 1972 · S/N 17260965 N20055Chesley Laurence J · Valdez, AKBuilt 1972 · S/N 17260967 N20056Haney Randall M · Boaz, ALBuilt 1977 · S/N 17702624 N20057Opiela Robert M · Hampton, NHBuilt 1972 · S/N 17260969 N20058Ballou Skies Aviation Inc · Bucyrus, OHBuilt 1972 · S/N 17260970 N2005GGreat Basin Aviation LLC · Eagle River, AKBuilt 1958 · S/N 51305 N2005QCoon Roger E · Springtown, TXFirst renewal noticeBuilt 1973 · S/N 177RG0405 N2005XTurnmire Jeffry B · Knoxville, TNBuilt 1965 · S/N 18256105 N20060Bakken George S · Terre Haute, INBuilt 1972 · S/N 17260972 N200617b Flying Club Inc · Sandpoint, IDBuilt 1972 · S/N 17260973 N20063Beery Milo A DBA · Clarinda, IABuilt 1972 · S/N 17260975 N20065Southern Aero LLC · Homestead, FLBuilt 1972 · S/N 17260977 N20068Spartanburg Area Flight Education LLC · Spartanburg, SCBuilt 1972 · S/N 17260980 N20069Montel Richard D · Candler, NCBuilt 1972 · S/N 17260981 N2006GYates Rodney R · Hubbard, ORS/N 51306 N2006QFarr Brad L · Uvalde, TXBuilt 1973 · S/N 177RG0406 N2006RBarclay Mechanical Services Of Utah Inc · Manti, UTBuilt 1963 · S/N 18255206 N2006ZN2006z LLC · South Hill, VABuilt 1963 · S/N 15059806 N20070Skywarrior Flight Training LLC · Pensacola, FLS/N 17260982 N20071Limaoscar LLC · Boca Raton, FLBuilt 1972 · S/N 17260983 N20072Ace Aviation 20072 LLC · Pembroke Pines, FLBuilt 1972 · S/N 17260984 N20073Gulf Coast Aviators LLC · Venice, FLBuilt 1972 · S/N 17260985 N20074Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1972 · S/N 17260986 N20079Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1972 · S/N 17260990 N2007QHopkins William · Reno, NVS/N 177RG0407 N2007RDoc'S Flying Club LLC · Macon, GABuilt 1963 · S/N 18255207 N2007TWinger Raymond E · Johnson, KSS/N 18258171 N2007YFoster Lemuel E · Vancouver, WABuilt 1962 · S/N 17249507 N2007ZRau John M · Liberty, KSBuilt 1962 · S/N 15059807 N20085Fleming Ian · Peoria, AZBuilt 1977 · S/N 17702626 N20089Eagle Air Inc · Schoolcraft, MIBuilt 1972 · S/N 17260999 N2008GChaump Michael · Reno, NVBuilt 1958 · S/N 51308 N2008QCoulter Dennis · Lincoln, CABuilt 1943 · S/N 177RG0408

Back to AD 87-20-03 R2