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.
N6216RRegistered aircraftN6217DSmithey Larry M · Wake Forest, NCN6217HWalker Robert J · Manvel, TXN6217JNathaniel Greene Dev Corp · Stanardsville, VAFirst renewal noticeN6217PYork Robert H · Zephyr Cove, NVN6218JNelson Jeffery M · Eagle River, AKN6218QOzarks Auto Show Inc · Hollister, MON6218UEkstrum Eric · Mound House, NVN6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXN6219AVann Dudley C · Greenville, NCN6219LBradley Jason · Fort Mohave, AZN621ACFlorida Institute Of Technology Inc · Melbourne, FLN621BAWilliams Travis D · Antlers, OKN621BDYeagle James A · Atlanta, GAN621BFBoldflight LLC · Danville, INN621BSStauter Mike D · Idabel, OKN621DCResource Extension LLC · Jupiter, FLN621EHofstetter Michael T · Saint James, MON621FJ8th Dimension Enterprises LLC · Aurora, ORN621FLKiani Behdad · Elk Grove, CAN621FTFlorida Institute Of Technology · Melbourne, FLN621GLOverwatch Tools Inc · Chesapeake, VAN621HDyer John T · Whispering Pines, NCN621HSBlue Skies Flying Services Inc · Lake In The Hills, ILN621LTWood Austin F · Seattle, WAN621MSAyagon Cecilia · Sequim, WAN621NDUnd Aerospace Foundation · Grand Forks, NDN621PAWings Over Texas Holdings LLC · Denton, TXN621PWSkyten Flying Club Inc · Orefield, PAN621RBentley Aero Inc · Wilmington, DEN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN621TKSheeptick LLC · Conrad, MTN621VBingham Lane M · Marble Falls, TXN62201Haenlein Kenneth · Southern Pines, NCN62209Christiansen Aviation LLC · Wilmington, DEN6220UBarnes Dennis W · Saint Joseph, MON6220WPuls Timothy W · Plainfield, ILN6221BJulius Kaleb · Mesa, CON6221LBorge Michael J · Chandler, AZN6221PLicata Paul Z · Mexico, MON6221UScott Terry · Panama City, FLN62221Lundell Levi T · Bolling Afb, DCN6222DRobertson C A · Phoenix, AZN6222HMortenson Lyle · Kennebec, SDN6222SClear Sky Aviation LLC · Lewis Center, OHN6223JVanderstoel Alex T · Waterford, CAN6223UHernandez Acosta Rodrigo Alejandro · El Paso, TXN6223VAxis Aviation LLC · Bloomingdale, GAN6224JRrr Transportation LLC · Oneonta, ALN6224LJohnson Lucas · Pleasant Lake, MI
Back to AD 90-04-06 R1