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.
N6943KLow And Slow Aviation LLC · Williston, FLN6943NPhoenix Aviation Holdings LLC · Mesa, AZN6944CUpdraft Leasing LLC · Tea, SDN6944EHinds Archie L · Claremore, OKN6944JJhap LLC · Hubbard, OHN6944NYates Gary Douglas · Rose Hill, KSN6944WWerner Robert T · Blue Grass, IAN6945JK&B Properties LLC · Lexington, SCN6945NEveland Benjamin E · Henderson, NVN6945PBerg Alvin L · Overgaard, AZN6945QEllis Jordan Barrett · Oklahoma City, OKN6945UGipe Douglas A · Malvern, IAN6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledN6946HPearson Kevin P · Dundee, ORN6946QBlalock James M · Sheridan, ARN6947BB&R Aerial Crop Care Inc · Connell, WAN6947NFlyfaraway Partners LLC · Sparta, NJN6947VGutierrez Juan · Sarasota, FLN6948KTerch Lawrence P Jr · North Pole, AKN6948NPeck Jeff · Denton, TXN6948WCraig Joshua G · Bonaire, GAN6949BPool Gene E · Anchorage, AKN6949KSaverio Gambassi · Bealeton, VAN6949NBanos Peter T · Coalinga, CAN6949PDepew Kevin I · Everett, WAN6949ULambert Donald H · Westwood, MAN6949VPaul Kevin A · Belgrade, MTN6949WSa Fliers LLC · Venice, FLN694ABGoldpick Dirtworx LLC · Wasilla, AKN694APCook Christopher W · Indian Mound, TNN694ARWilliams Robert R · Vernonia, ORN694BASlawko Paul A · Elverson, PAN694DCSweet Dixie Aviation LLC · Reddick, FLN694JSHowell Renny P · Whitehouse, TXN694LHChristiansen Aviation LLC · Wilmington, DEN694MLLindstrom Micah · Milaca, MNN694MPMohill Loren Dell · Murrieta, CAN694PBlack Robert · New Market, ALN694PKRule John H · Statesboro, GAN694PSSteger Paul M · Locust Grove, GAN694RMTavel Charles · Cave Creek, AZN694RSSnarr Randy L · South Jordan, UTN694SPFox Leasing Group LLC · Hollywood, FLN694VHall Davis Warren · Mobile, ALN6950BLudwig Henry H · Fort Worth, TXN6950DFaught Jeffrey R · Bismarck, NDN6950KGerhold Jeremy R · Rosharon, TXN6950PRegistered aircraftN6950RJefferson Airplane LLC · Port Hadlock, WAN6950WEalp LLC · Evansville, IN
Back to AD 90-04-06 R1