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.
N487BLBlue Line Aviation LLC · Smithfield, NCN487FLCarr Richard L · Cameron, WIN487PANipp Michael · Nampa, IDN487PVL00 Fliers LLC · Lewes, DEN487SPArchimedes Aviation LLC · Livermore, CAN487TWWood Thomas H · Granbury, TXFirst renewal noticeN487WBRice Leslie G · Berthoud, CON4880FFkm Air Shuttle LLC · Brooklyn, NYN4880GCifelli George J · Dothan, ALFirst renewal noticeN4880LHigginbotham Rome A · Zanesville, OHN4880TItechtives Company LLC · Purcellville, VAN48810Training Planes LLC · Tampa, FLN48816Feuerlein Maximilian · Tampa, FLN4881AAmstrup Jeremy T · Fairbanks, AKN4881EFulltron Aviation LLC · Springfield, MON4881LHoneycutt Stephen D · Ukiah, CAN4881TFuller Aire Inc · Wilmington, DEN4882AWilliams Donald B · Wingate, NCN4882EWalker Ray A · Sanger, TXN4882LArapahoe Flight Club LLC · Colorado Springs, CON48836Messenger Air Ltd · Madrid, IAN4883ECarricaburu Elliot A · Wasilla, AKN4883GPlane Nuts Aviation LLC · Livingston, LAN4883LMeixel Aviation LLC · Starbuck, MNN48842Elon Aviation LLC · Burlington, NCN48848Eaglet Flight Operations Lp · Fort Worth, TXN4884AGarfield Joe T · Morgan, UTN4884TRedstone Arsenal Flying Activity · Redstone Arsenal, ALN48856Neumeister Brian K · Edwardsville, ILN4885DSpartan National Holdings LLC · Missoula, MTN4885ESharr Ken D · Bigfork, MTN4885GS&P Aviation LLC · Albuquerque, NMN4885LMaximize Solutions Inc · Swan Lake, NYN4885ZReed Michael D · Parsons, KSN48868Hillsboro Aero Academy LLC · Hillsboro, ORN4886ACook Timothy D · Ashville, NYN4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeN4886LNortheast Florida Aero Club Inc · Fleming Island, FLN4886MPayne William E · Elizabeth, CON48878Kilo Lima Investments LLC · Huntington Beach, CAN48879Matson Dean R · Spring, TXN4887GSouthern Aero LLC · Homestead, FLN4887TRoe John C · Bonners Ferry, IDN48883Fly Kful Inc · Fullerton, CAN48887Fault Line Flyers · Leander, TXN4888G578 Airplane Leasing Inc · Kissimmee, FLN4888HRudisel Timothy A · Kewadin, MIN4888LAshton Marc J · Petaluma, CAN4888TTevik Michael A · Provo, UTN4888ZFrancom Jeffery S · Malad City, ID
Back to AD 90-04-06 R1