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.
N803RMAs Filed LLC · Culver City, CAN803RTShuler Air Corps LLC · Wilmington, DEN803SBEatinger Alvin R · Ashland, ORN803SPDodson International Parts Inc · Rantoul, KSN803TWGsfcpp Corp · Palm City, FLN8040Collins Leon Marshall · Ozark, ALN80407N80407 LLC · Rehoboth Beach, DEN8040DReboot Charity Inc · West Palm Beach, FLN8040PSutton Thomas C · Corning, NYN8040WJeff Abrams-2 LLC · Ocala, FLN8040ZZilinsky Robert F · Willowbrook, ILN80414Garn Darrell L · Palmetto, GAN80419Korona Lawrence K · West Paterson, NJN8041WBas Part Sales LLC · Greeley, CON80421Kuder Kyp E · Rogers, NDN80424Johnston Robert K · Sylvania, GAN80425Fellows Roy H · Augusta, KSN8042BSummerskyz Inc · Saint Joseph, ILN8042DYounger Tyler J · Bakersfield, CAN8042FFlying Hawks Inc · Palmyra, WIN80434King William Daniel · Southlake, TXN80436N80436 LLC · Columbia, MSN80439Oklahoma State University · Stillwater, OKN8043GConnor Robert L · North Little Rock, ARN8043JHartland Helicopters LLC · Edinburg, TXN8043RPat Brown Aviation LLC · Dodge Center, MNN8043UClassic Banjo LLC · Richmond, KYN8043WMcabee Aviation LLC · Fresno, CAN8043YN56453 LLC · Bowie, MDN80440Rockey John · Jupiter, FLN80441Archer Aircraft LLC · Wilmington, DEN80442Washburne Seth P · Dallas, TXN8044DGillen Sean P · Arlington, TXN8044GTml Services LLC · The Villages, FLN8044LOverton Larry D · Hermiston, ORN8044NN7396w LLC · Coeymans Hollow, NYN8044RCobb Gerald E · Jacksonville, FLN8044TArcher Aircraft LLC · Wilmington, DEN8044WKananen Agency Inc · Joliet, MTN80454Tadao LLC · Tucson, AZN80456Barash Geva S · Ashland, MAN80458Kolpack Glenn H · Sonora, CAN8045CConrad Daniel R · Sweet Home, ORN8045DLarson Larry E · Twin Valley, MNN8045KEmerald City Aircraft Leasing Inc · Port Orchard, WAN8045NCti Aircraft Leasing LLC · Memphis, TNN8045RCcf Ventures Inc · Bangor, MEN8045SHenry Mark A · Dickinson, TXN8045WOpen Engineering LLC · Ames, IAN80469Hetherly Bryce D · Clintondale, NY
Back to AD 90-04-06 R1