AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.
N5912DRenner David L · Ferndale, CAFirst renewal noticeN5912PHarris Gerald Trustee · Rancho Murieta, CAN5913DCaldwell Caleb Z · Anchorage, AKN5913PMercer Gary L · Eaton, OHN5914PAnderson Harry E · Missoula, MTN5915DMason Jack A · Reidsville, NCN5915PBair James R · Lucas, IAFirst renewal noticeN5917PRanger Aviation Inc · Burlington, CON5917ZKoch Christopher P · Batavia, NYN591NDUnd Aerospace Foundation · Grand Forks, NDN5920DBates Matthew T · Springfield, VAN5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSN5922PWiseman Transport LLC · Henderson, TXN5922YUltimate Air Parts LLC · Strasburg, VAN5922ZBellamy John Mark · Freeville, NYN5924PPope Mark I · Arco, IDN5926DToste Greg · Newcastle, CAN592NDUnd Aerospace Foundation · Grand Forks, NDN5930YHopkins Frank Michael · Wilmington, DEN5930ZBrue Peter Gary · Cedar Rapids, IAN5931DStone Robert K · Piney Flats, TNN5933DHoward Trent R · Mandan, NDN5934DBalsley Matthew G · Rowlett, TXN5934ZNew Daniel A · Deming, WAN5935PDaniel Hardy L Jr · Derby, KSN5936DSchreiber Faith E · Valparaiso, INN5936ZMeulenberg Jacobus M J · Schenevus, NYN5937PTindall Michael C · Granite City, ILN5937ZFurman Maximillian · Barnum, MNN5938YFly For Fun Aircraft LLC · Rockville, MDN593NDChristiansen Aviation LLC · Wilmington, DEN5940DRunnin Rabbit LLC · Kalispell, MTN5940ZMoore Roger W · Poinciana, FLN5941ZByler Jonathan P · Inman, SCN5942DFour For Flying Inc · Holyoke, CON5943PHarper Carlyle W · Ocilla, GAN5944DBradley Dennis Michael · Myrtle Beach, SCN5944PMay Russell L · Las Cruces, NMN5945DKline Paul R · Mapleton Depot, PAN5945ZThompson Neal R · Magnolia, DEN5946DInsite Design LLC · Indianapolis, INN5946PHoward W E Barney · San Marcos, TXN5946Z507 Flying Club Inc · Leetonia, OHN5947DPayne David J · Eagle River, AKN5947PJam Naba Sem LLC · Beavercreek, OHN5948DHumble Servant LLC · Salem, WIN5948POverstreet Robert S · Clarksville, VAN5948YFbm LLC · Laporte, INN5949DWick Marcel P · Warsaw, NYN5949PDyer Thomas L · Sparks, NV
Back to AD 85-02-05 R1