Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-R1') 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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N6242JEast Coast Autoline LLC · Whitehall, PAS/N 28-7625234 N6242WPettie Randall D · Baltimore, MDBuilt 1964 · S/N 28-20239 N6244WTaylors Turf Paradise LLC · Whitewater, WIBuilt 1964 · S/N 28-20288 N6249WWall Scott R · Franksville, WIBuilt 1964 · S/N 28-20295 N6250WCummings Property Restoration LLC · Bullard, TXBuilt 1964 · S/N 28-20296 N6252WBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 28-20299 N6254WHayes George L · Longmont, COBuilt 1964 · S/N 28-20302 N6255WCrumpler Stephen M Jr · Smithfield, NCBuilt 1964 · S/N 28-20303 N6259WVision Of Flight Inc · Orlando, FLBuilt 1964 · S/N 28-20308 N625FLFly Foxtrot Lima LLC · Philadelphia, PABuilt 1971 · S/N 28-7125514 N6261WStar 1 LLC · Canyon Country, CAS/N 28-20310 N6262WRegistered aircraftBuilt 1964 · S/N 28-20293 N6268WTereshchenkov Nikita · Edgewood, WABuilt 1964 · S/N 28-20316 N626BCherokee Family Limited Partnership · Watsonville, CABuilt 1964 · S/N 28-2094 N626MJGreathouse Nicholas Lee · Casa Grande, AZBuilt 1976 · S/N 28-7625134 N626PMMckivergan Michael · Yuma, AZBuilt 1967 · S/N 28-4098 N6270WMaple City Aviatiors LLC · Laporte, INBuilt 1964 · S/N 28-20318 N62715Probst Vincent G · Lutz, FLBuilt 1967 · S/N 28-23382 N6273WBelfino Nicholas E · Dallas, PABuilt 1964 · S/N 28-20322 N6276WCable Philip L · Cable, WIS/N 28-20326 N6277WMcnew John P · Brighton, COBuilt 1964 · S/N 28-20327 N6278WSummars Roger N · Buffalo, OKBuilt 1964 · S/N 28-20328 N6279Wings Of Grace LLC · Orlando, FLBuilt 1965 · S/N 28-21148 N6279WArtus Stephen Douglas Jr · Pelican Lake, WIBuilt 1964 · S/N 28-20329 N6281WFugate Robert S II · Scottsdale, AZBuilt 1964 · S/N 28-20331 N6282WSale Reported · Carthage, MSSale reportedS/N 28-20332 N6283WEfficientflight Aviation LLC · Naples, FLBuilt 1965 · S/N 28-21262 N6284WWd Environmental Services Inc · Wauchula, FLBuilt 1964 · S/N 28-20224 N6286WWestern Plains Aviation LLC · Greeley, COBuilt 1964 · S/N 28-20242 N6287WHobbs Jason · Saint Francisville, LABuilt 1964 · S/N 28-20245 N6288WRegistration Pending · Fort Lauderdale, FLRegistration pendingS/N 28-20254 N6289WCronk Howard · Council Bluffs, IABuilt 1964 · S/N 28-20233 N6291WBrenton Perry · Crestview, FLBuilt 1964 · S/N 28-20335 N6292WAmerican Aviator LLC · Arlington, TXBuilt 1964 · S/N 28-20336 N6293WFisher Russell D · Vacaville, CABuilt 1964 · S/N 28-20338 N6295WJ Delgado Aviation LLC · Tulsa, OKBuilt 1964 · S/N 28-20340 N6296WBarthell Frederick · Sun City West, AZS/N 28-20341 N6297WDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1964 · S/N 28-20342 N62RMEmployment Services Inc · Virginia Beach, VABuilt 1962 · S/N 28-352 N6300JWoltman Roger · Cherokee, IABuilt 1968 · S/N 28-4709 N6301JMorais Antonio L · Greenacres, WABuilt 1968 · S/N 28-4712 N6301WKap Title Inc · Tucker, GABuilt 1964 · S/N 28-20344 N6302JFlying Three Inc · Milton, KSBuilt 1968 · S/N 28-4713 N6302RAiken Joshua · Plano, TXBuilt 1966 · S/N 28-21467 N6303RDorris Chris DBA · Mount Juliet, TNFirst renewal noticeBuilt 1966 · S/N 28-21468 N6304JFlying Colts Inc · Rew, PABuilt 1968 · S/N 28-4715 N6304RBastida William M · San Rafael, CABuilt 1966 · S/N 28-21469 N6306JCampbell Christopher J · Enterprise, ALBuilt 1968 · S/N 28-4717 N6306WNovotny Warren · Wadsworth, OHS/N 28-20350 N6307WJohnson Bradley M · Belgrade, MTS/N 28-20351

Back to AD 96-10-01 R1