Skip to content

Registered aircraft · 3,118

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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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.

N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715 N5651PSeremet Cristina L · Beaver Dam, WIBuilt 1959 · S/N 24-722 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725 N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727 N566BSSand Farm Management Services LLC · Adel, IABuilt 1970 · S/N 39-56 N5670PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-742 N5674PNeely Antwuan T · Savoy, ILBuilt 1959 · S/N 24-746 N5675PLandolt Gregg E · Moreno Valley, CABuilt 1959 · S/N 24-747 N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756 N5686PGray Gary L · Frederick, OKBuilt 1959 · S/N 24-758 N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763 N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766 N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772 N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297 N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773 N5702PChilds Group Inc · Altoona, IABuilt 1959 · S/N 24-775 N5705PN5705p Inc · Pompano Beach, FLBuilt 1959 · S/N 24-778 N5709PSaadjack LLC · Amelia Island, FLBuilt 1959 · S/N 24-783 N5712PGibson Kevin M · Denver City, TXBuilt 1959 · S/N 24-786 N5717PGraber Tim B · Santee, CABuilt 1959 · S/N 24-791 N5720PPatterman Emil S · Fort Worth, TXS/N 24-794 N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796 N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799 N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802 N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803 N5733PStrattner Brian J · Chesapeake, VABuilt 1959 · S/N 24-807 N5745PMiller Aaron T · New Braunfels, TXS/N 24-819 N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820 N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823 N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825 N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826 N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834 N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836 N5760PLoughlin Robert J · Midland, TXBuilt 1959 · S/N 24-838 N5765PWomack Calvin E · Lakeside, TXBuilt 1959 · S/N 24-843 N5766PMid Pacific Aero Services LLC · Honolulu, HIS/N 24-844 N5767PMcdowra Christopher L · Paris, TXS/N 24-845 N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846 N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849 N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850 N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853 N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857 N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858 N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848 N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859 N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861

Back to AD 82-23-01 R1