Registered aircraft · 114

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

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:2006-14-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-14-08') ORDER BY n_number

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:2006-14-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-14-08')
  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:2006-14-08')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-14-08')
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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SA N1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N117HGobuyair LLC · Flint, MIBuilt 1979 · S/N 751SA N122CKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 374SA N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SA N130MS3b Leasing LLC · Fairhope, ALS/N 750SA N140CPColumbia Asset Trust Corp Trustee · Wichita, KSS/N 362SA N145FSSolitaire LLC · Appleton, WIS/N 437 S.A N14VLJpw Aviation LLC · Clarksdale, MSBuilt 1981 · S/N 1514SA N15TRNorthwest Aviation LLC · Fargo, NDBuilt 1981 · S/N 446 S.A.N1727SN1727s LLC · Calhoun, GAS/N 1504 S.A.N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SA N178SBCrawford Setrige · Santa Barbara, CAS/N 435 S.A.N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N193AABig Mountain Aviation Inc · Whitefish, MTBuilt 1979 · S/N 741SA N196MAStef Air LLC · Muscle Shoals, ALBuilt 1979 · S/N 764 S.A.N200GCameron Global Strategies LLC · Springboro, OHBuilt 1981 · S/N 452 S.A.N219MAJa1 Aviation LLC · Sedan, KSBuilt 1981 · S/N 440 S.A.N21HPExcalibur Enterprises LLC · Gainesville, VABuilt 1977 · S/N 357SA N220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222FAExpress Aviation Management LLC · Dover, DES/N 714SA N22MKLhb Aviation LLC · Williamsburg, VAS/N 375SA N24WCDach Capital Holdings Inc · Newark, DES/N 705SA N252BWMotor Vanguard LLC · Campbellsville, KYBuilt 1980 · S/N 423 S.A.N271TWBaker Aviation LLC · Dover, DES/N 734 S.A.N2RAFlying Mu2 LLC · Reno, NVS/N 366SA N2RRMelocity Air LLC · Saint Petersburg, FLBuilt 1981 · S/N 454 S.A.N30MAWilson Construction Delaware Corp · Ketchum, IDBuilt 1978 · S/N 371SA N321GMWestern News & Info Inc · Prescott Valley, AZBuilt 1981 · S/N 1505 SA N32ECAlan H Brodine Dmd Pc · Rochester, NYBuilt 1977 · S/N 699SA N333ZPWashington Road Properties Level 2 LLC · Highlands, NCS/N 363SA N338MLJdm Aviation LLC · Marceline, MOBuilt 1981 · S/N 1539SA N33EWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1981 · S/N 1519 S.A.N350RGAdams Michael D · Mckinney, TXBuilt 1980 · S/N 773 S.A.N352WMMu-2 American Services Inc · Dover, DEBuilt 1978 · S/N 385SA N356AJRealstaff Rocket LLC · Keizer, ORBuilt 1978 · S/N 381SA N360RAMillennium Flight Leasing Inc · Wilmington, DES/N 740SA N361MAReturnlogic Inc · Apollo Beach, FLBuilt 1980 · S/N 429 S.A.N36ATPlanesusa.Com LLC · Dover, DEBuilt 1980 · S/N 426 S.A.N370MAAir 1st Aviation Companies Inc · Aiken, SCS/N 370SA N3MAAir 1st Aviation Compainies Inc · Aiken, SCS/N 1511 S.A.N400PSBarnett Sheila · Catoosa, OKBuilt 1979 · S/N 411 S.A.N40AMAisling Developments LLC DBA · Calhoun, GABuilt 1980 · S/N 427 S.A.N40JJIntercontinental Jet Service Corp · Tulsa, OKBuilt 1978 · S/N 383SA N423DB2945l LLC · Terrell, TXS/N 1543 S.A.N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N444WFZadeh Aviation Group LLC · El Centro, CAS/N 1551 S.A.N449BKMu2b40 LLC · Rancho Santa Fe, CABuilt 1981 · S/N 449 S.A.N44AFTrinity Group · Watford City, NDBuilt 1981 · S/N 790SA

Back to AD 2006-14-08