AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N606TTTotusek Torger · La Palma, CAN606WLarson Bernard J · Mt Vernon, WAN6070LPloski Greg · Prospect, CTFirst renewal noticeN6070NKnott Donnie W · Milan, TNN6070QOdenbach Eric J · Eureka, SDN6070WHocking Christopher J · Hinckley, MNN6071DRiffle Thane G · Addy, WAN6071QHaven Hospitatlity LLC · San Marino, CAN6071WAbbott Joseph D · Chippewa Falls, WIN6072LLawrence Blake C · Monument, ORN6072NDilecce Joseph · Sarasota, FLN6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CAN6072WHillman Maritime Services LLC · Lafayette, LAN60733Rentner Judith E · Bigfork, MTN6073DDetrick Louis F · Eighty Four, PAN6073LKottke Benjamin P · Central Point, ORN6073NRozinka Jay C · River Falls, WIN6073PBradshaw James L · Lenoir, NCN6074NParlog Roy H · Irwin, PAN6074PBerlingen Michael W · Oregon City, ORN6074QMiranda Edward G · Prescott Valley, AZN6074VBabb Bradley E · Enid, OKN6074WRegistration Pending · Los Angeles, CARegistration pendingN6075LChandler Air Service Inc · Chandler, AZN6075PMoore Leslie D · Raymore, MON6075VLister Cameron M · Loxley, ALN6075WVolk Alyssa M · Jordan, MNN6076DPinnow Andrew W · Cheshire, CTN6076GColbert Farms Inc · Davenport, WAN6076MRomano Victor J Jr · Wasilla, AKN6076WBlyseth Brent A · Germantown, TNN6077DPargman Curtis A · Big Lake, MNN6077EAir Fleet Holdings LLC · Addison, TXN6077NKrig Marie · Seattle, WAN6077WParrish Stephen W · Minneola, FLN6078DWagar Dennis Murphy · Marion, MTN6078FAmeriflyers Of Texas Inc · Addison, TXN6078LHott Jack R · Springboro, OHN60798Hjl Farm Inc · Dagmar, MTN6079WAmos Warren E · Cypress, TXN6079ZSimmons Aviation Services LLC · Pawcatuck, CTN607DCRegistration Pending · Groton, MARegistration pendingN607DSNasir Rehan S · Lancaster, PAN607EABlue Horizons Flying Club Inc · Perrysburg, OHN607FTFlorida Institute Of Technology · Melbourne, FLN607NDUnd Aerospace Foundation · Grand Forks, NDN607PTAzure Leasing LLC · Oakdale, PAN607RVGlick Richard A · Mesquite, NVN607SCN-88xk Medical Aviation LLC · Pittsburgh, PAN6080LBowers Scott · Soddy Daisy, TN
Back to AD 90-04-06 R1