AD 90-04-06 R1
Registered aircraft · 68,369
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.
N1606RStansel Jon S · Conway, ARN1607HHanson Jeffrey L · Fuquay Varina, NCN1607REash Neal S · Louisville, TNN1608GDrexler William G · Peyton, CON1609EEilenfeld Teresa · Mansfield, OHN1609RJohnson Henry D · Buena Park, CAN160BAHitec Construction Services Inc · Lincoln, CAN160BCPridmore Reginald C · Laughlin, NVN160CAPrice Keyth E · Ossian, INN160CBBishop Christopher S · Houston, TXN160CWAbraham Elizabeth J · Browntown, WIN160DPrice Paul L · Lancaster, VAN160DBAguilar Theodore · Bozeman, MTN160DEPeters David E · Trumbull, CTN160DGRed Baron LLC · Middletown, DEN160EGAero Exports LLC · Van Nuys, CAN160FCroxton Malcolm Alan · Torrance, CAN160FSModi Yogini · Homestead, FLN160GBEagle Aviation LLC · Anchorage, AKN160GTKalies Richard L Trustee · Plymouth, WIN160HLProbasco Mitchell L · Floydada, TXN160HPLache Benjamin · Port Orange, FLN160JRRhinehart Gerald A Jr · Lordstown, OHN160KPWorman Clinton L · Volborg, MTN160LTodd Victor E · London Mills, ILN160LMMino Leonard G · Pueblo West, CON160MLLindsey Roy M · Thorsby, ALN160MPOverton Wallace L · Waxhaw, NCN160MRStanley Kathryn Elizabeth · Santa Margarita, CAN160MTRegistration Pending · Richmond, TXRegistration pendingN160NHSale Reported · Xxx, OKSale reportedN160PTPilot Training Center LLC · Miami, FLN160RFYank-N-Bank LLC · Greeley, CON160RVAsleson James E · Intl Falls, MNN160STJonathan Job Latham Enterprises LLC · Palmhurst, TXN160THolmberg Michael G · Hinckley, OHN160TPContrail Aviation Inc · Cheboygan, MIN160TXStark Micah S · La Quinta, CAN160WBBeach Banners Inc · Jacksonville, FLN160WMSirvelis Aras J · Anchorage, AKN160WPGeorgia Aircraft Partners LLC · Peachtree City, GAN160YAnthonson Ronald G · Cortland, NYN1610ABauder Robert J · Soldotna, AKN1610GVeenstra Timothy S · Wasilla, AKN1611AJones William Ransom · Anchorage, AKN1611CNorthern Flyway LLC · Anchorage, AKN1611HPlane Fun Inc Tr Trustee · Snellville, GAN1611PBoyer Scott C · Custar, OHN1611RFi Fi Flyers LLC · Littleton, MAN16122Dexter Fred H · Live Oak, FL
Back to AD 90-04-06 R1